봐) 1. 데이터 독립화 2. 데이터 중복 최소화, 데이터 무결성 보장 3. 데이터 보안 향상 4.... 조회 SELECT EMP_NAME, DEPT_CODE, SALARY FROM EMPLOYEE WHERE DEPT_CODE = ‘D6’ OR SALARY > 2000000; -연결 연산자...
조회 SELECT EMP_NAME, SALARY*12, (SALARY*(1+BONUS))*12, (SALARY*(1+BONUS))*12 - (SALARY*12)*0.03 FROM EMPLOYEE; -- 2. EMPLOYEE 테이블에서 이름, 고용일, 근무일수 (오늘 날짜 - 고용일) 조회...
구문 1. 구조 SELECT (COLUMN 이름) + FROM (테이블 이름) + 커맨드(WHERE, ORDER BY …) 2. SELLECT 특정... 따라서 위의 코드에서 ORDER BY WORKING_AREA ASC AND AGENT_NAME DESC; 를 입력하는 경우 오류가 발생합니다....
속성 name의 데이터를 조회한다. - 논리 연산자(and, or, not) 사용이 가능하며, 논리... select distinct name from professor (1) order by name; // 내림차순, 알파벳 순서로 정렬된다. (2) order by...
-
follows: Select Case [variable] Case [condition 1] [Statement 1] Case [condition 2]... com/ Public Sub Select_Case_Example() ' Read value from cell A1 on sheet1 Dim airportCode As...
Must evaluate to one of the elementary data types (Boolean, Byte, Char, Date, Double... to 9 or 10") Case Else Debug.WriteLine("Not between 1 and 10, inclusive") End Select
... Statement lis = con.createStatement(); System.out.println("1.전체조회 2.한명조회 3.회원추가 4.... switch(check){ case "2" : ResultSet ls = lis.executeQuery("SELECT * FROM 회원 WHERE name LIKE (?)"); System.out....
... p_name, A.p_ename, A.p_price1, A.p_price2, A.p_dcnum, A.p_buyend, A.RRP_confirm, A.RRP_DC, A.RRP_MGroup FROM ( SELECT DISTINCT G_CODE FROM BS_GOODS_GROUP WHERE ((REPLACE(BC_ID, ' ', '') = '1') OR (BC_ID in (SELECT BC_ID FROM...
1. Dim con As New ADODB.Connection Dim rec As New ADODB.Recordset 2. Private Sub Form_Load() Me.Left = (Screen.Width... Open "select * from table1", con, adOpenDynamic... DataField = "NAME" Set Text3.DataSource = rec Text3.DataField...
... SELECT TO_CHAR(hire_date,'mm') FROM EMPLOYEES SELECT d.department_name "부서", DECODE(TO_CHAR(hire_date... SELECT d.department_name "부서", COUNT(DECODE(TO_CHAR(hire_date,'mm'), '01','1') ) "1월", COUNT(DECODE(TO...
... class or styles here by modifying // the CREATESTRUCT cs return... CImgProcView::AssertValid() const { CScrollView::AssertValid(); }... parameter 1 from 'unsigned char ** ' to 'int ** ' 입니다; 모가...
... Nothing Or Target.Value = "" Then Exit Sub Debug.Print Sh.Name If IsNumeric(Target.Value) Then strTrim = Trim(Str(Target.Value)) If InStr(1, strTrim, ".") < 1... " With Range(strRng) .Select .Value = "" End With End If...