Open snaag opened 1 month ago
MySQL - SQL
/ 오라클 - PL/SQL
/ SQL Server - Transact SQL
ANSI 스타일
SELECT E.EMP_ID
, E.EMP_NAME
, E.SALARY
, D.DEPT_NAME
FROM EMPLOYEE E JOIN DEPARTMENT D
ON (E.DEPT_NO = D.DEPT_NO)
WHERE D.DEPT_NO = 2;
-- 예제 출처 https://velog.io/@iamhyunji/DB-ANSI-SQL
Oracle 스타일
SELECT E.EMP_ID
, E.EMP_NAME
, E.SALARY
, D.DEPT_NAME
FROM EMPLOYEE E,DEPARTMENT D
WHERE E.DEPT_NO = D.DEPT_NO
AND D.DEPT_NO = 2;
-- 예제 출처 https://velog.io/@iamhyunji/DB-ANSI-SQL
Reference