#3 Select 잘 이용하기 (2)

SELECT name, math, english, korean  FROM exam_result
ORDER BY 3 DESC;

3번째 Column을 기준으로 정렬하기

SELECT *FROM exam_result
UNION 
SELECT *FROM exam_result_2;

테이블 2개 합치기 (UNION 중복제거, UNION ALL 전부)

SELECT * FROM math_student
MINUS
SELECT * FROM korean_student;

SELECT * FROM math_student
INTERSECT
SELECT * FROM korean_student;

차집합, 교집합