데이터베이스 2장(2010/8/23) 오전수업
SElECT * FROM employees; SELECT employee_id ,first_name ,salary FROM employees; select employee_id, first_name, salary from employees; SELECT employee_id ,first_name ,salary FROM employees WHERE job_id = 'SA_REP' ORDER BY salary DESC, first_name ASC SELECT -35+40*2 FROM dual; SELECT employee_id , job_id ,salary FROM employees WHERE job_id='IT_PROG' AND salary>=8000; SELECT employee_id , first_na..
더보기