- Sorting by Multiful Columns靑峰select last_name, department_id, salary from employees order by department_id, salary desc ;
- 2007-10-16 21:42:10
- Sorting by Column Alias靑峰select employee_id ,last-name, salary*12 annsal from employees order by annsal ;
- 2007-10-16 21:40:25
- Sorting in Descending Order靑峰select last_name, job_id, department_id, hire_date from employees order by hire_date desc ;
- 2007-10-16 21:38:22
- ORDER BY Clause靑峰select last_name, job_id, department_id, hire_date from employees order by hire_date ;
- 2007-10-16 21:36:43
- Rules of Precedence靑峰select last_name, job_id, salary from employees where (job_id = 'SA_REP' or job_id = 'AD_PRES') and salary > 15000 ;
- 2007-10-16 21:34:54
- Using the (AND / OR / NOT) Operator靑峰select employ_id, last_name, job_id, salary from employees where salary >= 10000 and job_id Like '%MAN%' ; select employ_id, last_name, job_id, salary from employees where salary >= 10000 or job_id Like '%MAN%' ; select last_name, job_id from employees where job_id not in('IT_PROG', 'ST_CLERK', 'SA_REP') ;
- 2007-10-16 21:31:11
- Using the MULL Conditions靑峰select last_name, manager_id from employees where manager_id is null ;
- 2007-10-16 21:25:44
- Using the LIKE Condition靑峰select first_name from employees where first_name like 'S%' ; select last_name from employees where last_name like '_O%' ;
- 2007-10-16 21:22:19
- Using the IN Conditions靑峰select employee_id, last_name, salary, manager_id from employees where manager_id in(100, 101, 201) ;
- 2007-10-16 21:19:54
- Using the BETWEEN Conditions靑峰select last_name, salary from employees where salary between 2500 and 3500 ;
- 2007-10-16 21:18:04
스킨 업데이트 안내
현재 이용하고 계신 스킨의 버전보다 더 높은 최신 버전이 감지 되었습니다. 최신버전 스킨 파일을 다운로드 받을 수 있는 페이지로 이동하시겠습니까?
("아니오" 를 선택할 시 30일 동안 최신 버전이 감지되어도 모달 창이 표시되지 않습니다.)