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.
30 lines
500 B
30 lines
500 B
USE Study
|
|
GO
|
|
|
|
-- BETWEEN
|
|
SELECT * FROM EMPLOYEE
|
|
WHERE SALARY BETWEEN 400 AND 600
|
|
|
|
-- IN
|
|
SELECT ENAME, JOB FROM EMPLOYEE
|
|
WHERE JOB IN ('section', 'senior')
|
|
|
|
-- IS NULL
|
|
SELECT * FROM EMPLOYEE
|
|
WHERE COMMISSION IS NOT NULL
|
|
|
|
-- LIKE
|
|
-- %: 임의 길이 문자열, _: 한글자 문자
|
|
SELECT * FROM DEPARTMENT
|
|
WHERE DNAME LIKE 'H%n'
|
|
|
|
|
|
-- ORDER BY
|
|
SELECT ENAME, SALARY, DNO
|
|
FROM EMPLOYEE
|
|
ORDER BY SALARY DESC
|
|
|
|
-- ORDER BY (다중 속성 정렬), TIE BREAK
|
|
SELECT ENAME, SALARY, DNO
|
|
FROM EMPLOYEE
|
|
ORDER BY SALARY DESC, DNO ASC |