Peace
/
mssql_Study
1
0
Fork 0
Code Issues Pull Requests Packages Projects Releases Wiki Activity
You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
12 Commits
1 Branch
0 Tags
51 KiB
Tag: Branch: Tree: master
Branches Tags
${ item.name }
Create tag ${ searchTerm }
Create branch ${ searchTerm }
from 'master'
${ noResults }
mssql_Study/subquery.sql

49 lines
1.2 KiB
Raw Permalink Normal View History Unescape

중첩 질의문
3 years ago
USE Study
GO
SELECT DNAME
FROM DEPARTMENT
WHERE DEPARTMENT.DNO = (SELECT DNO
FROM EMPLOYEE
WHERE EMPLOYEE.ENO = 103)
-- <EFBFBD><EFBFBD> <EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD> <EFBFBD><EFBFBD><EFBFBD><EFBFBD>
SELECT DNAME
FROM DEPARTMENT
JOIN EMPLOYEE ON EMPLOYEE.DNO = DEPARTMENT.DNO
WHERE EMPLOYEE.ENO = 103
-- <EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD> <EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>
SELECT ENO,DNO
FROM EMPLOYEE
WHERE EMPLOYEE.DNO = (SELECT DNO FROM EMPLOYEE WHERE EMPLOYEE.ENO = 110)
-- <EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD> <EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>
SELECT ENAME, ENO,DNO, SALARY
FROM EMPLOYEE
WHERE EMPLOYEE.DNO IN (SELECT DNO FROM EMPLOYEE WHERE SALARY >= 500)
SELECT ENAME, ENO,DNO, SALARY
FROM EMPLOYEE
WHERE SALARY >= ANY (SELECT SALARY FROM EMPLOYEE WHERE DNO = 20)
SELECT ENAME, ENO,DNO, SALARY
FROM EMPLOYEE
WHERE SALARY >= ALL (SELECT SALARY FROM EMPLOYEE WHERE DNO = 10)
SELECT ENAME
FROM EMPLOYEE
WHERE EXISTS (SELECT * FROM EMPLOYEE WHERE SALARY + COMMISSION > 500)
SELECT ENO, ENAME, DNO, SALARY
FROM EMPLOYEE
WHERE DNO IN (SELECT DNO FROM EMPLOYEE WHERE ENO = 101)
AND SALARY IN (SELECT SALARY FROM EMPLOYEE WHERE ENO = 101)
-- <EFBFBD><EFBFBD>ȣ <EFBFBD><EFBFBD><EFBFBD><EFBFBD> <EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>: <EFBFBD>Ϲ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD> <EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD> <EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>, <EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD> <EFBFBD><EFBFBD><EFBFBD>°<EFBFBD> <EFBFBD><EFBFBD><EFBFBD><EFBFBD>
-- (<EFBFBD><EFBFBD><EFBFBD><EFBFBD> <EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD> <EFBFBD><EFBFBD><EFBFBD><EFBFBD> <EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD> <EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD> <EFBFBD>޶<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD> <EFBFBD><EFBFBD>ȣ <EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD> <EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD> <EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD> <EFBFBD><EFBFBD>ȸ<EFBFBD><EFBFBD> <EFBFBD><EFBFBD><EFBFBD><EFBFBD>)
SELECT ENO, ENAME, SALARY, DNO
FROM EMPLOYEE AS E
WHERE DNO IN (SELECT DNO FROM EMPLOYEE AS M WHERE E.MANAGER = M.ENO)