sql
-
SQL SELECT StudyDB/SQL 2018. 8. 3. 17:39
-- 5. 이름(FIRST_NAME)의 두 번째 글자가 'a'인 사원의 이름(FIRST_NAME)과 연봉을 조회하라.SELECT FIRST_NAME, SALARYFROM EMPLOYEESWHERE FIRST_NAME LIKE '_a%'; -- 21. 모든 사원들의 사원번호, 부서명, 직무명, 도시명을 조회하라.SELECT E.EMPLOYEE_ID, D.DEPARTMENT_NAME, J.JOB_ID, L.CITYFROM DEPARTMENTS D , LOCATIONS L , EMPLOYEES E , JOBS JWHERE E.DEPARTMENT_ID = D.DEPARTMENT_IDAND D.LOCATION_ID = L.LOCATION_IDAND J.JOB_ID = E.JOB_ID; -- 37. 자신의 상사가 ..
-
SQL - JOIN, SUB QUERY, INLINE TABLE, IN VIEWDB/SQL 2018. 8. 3. 16:36
SELECT *FROM EMPLOYEESWHERE DEPARTMENT_ID IN ( SELECT DEPARTMENT_ID FROM EMPLOYEES WHERE FIRST_NAME = 'Steven' )AND FIRST_NAME != 'Steven' -- 여러개일때는 IN 사용; SELECT E.EMPLOYEE_ID, E.FIRST_NAME, E.LAST_NAME, E.SALARY, D.DEPARTMENT_NAMEFROM EMPLOYEES E, DEPARTMENTS DWHERE SALARY > ( SELECT ROUND( AVG(SALARY), 0 ) FROM EMPLOYEES )ORDER BY SALARY; SELECT E.*FROM DEPARTMENTS D , LOCATIONS L , EMPLOYEES..
-
SQL - SELECTDB/SQL 2018. 8. 1. 17:24
SELECT FIRST_NAME , LAST_NAMEFROM EMPLOYEES; SELECT *FROM EMPLOYEES; SELECT CITYFROM LOCATIONS; SELECT DEPARTMENT_NAMEFROM DEPARTMENTS; SELECT COUNTRY_ID , COUNTRY_NAMEFROM COUNTRIES; SELECT DISTINCT MANAGER_ID , FIRST_NAMEFROM EMPLOYEESORDER BY MANAGER_ID DESC; SELECT *FROM EMPLOYEESORDER BY EMPLOYEE_ID ASC; SELECT *FROM EMPLOYEESORDER BY SALARY DESC; SELECT *FROM EMPLOYEESORDER BY HIRE_DATE AS..