SELECT 칼럼명 [ALIAS명] FROM 테이블명 [WHERE 절]
[GROUP BY 절] [HAVING 절] **[ORDER BY 칼럼/표현식 [ASC/DESC]]**;
SELECT PLAYER_NAME, POSITION, BACK_NO FROM PLAYER
WHERE BACK_NO IS NOT NULL OERDER BY HEIGHT DESC, BACK_NO;
SELECT PLAYER_NAME, POSITION, BACK_NO FROM PLAYER
WHERE BACK_NO IS NOT NULL OERDER BY HEIGHT DESC, 3;
FROM 절에 정의되지 않은 칼럼을 WHERE, GROUP BY, HAVING, SELECT, ORDER BY 절에서 사용 불가
SELECT MGR FROM (SELECT EMPNO, ENMAE FROM EMP ORDER BY MGR); -- SELECT MGR 오류
SELECT JOB FROM EMP GROUP BY JOB HAVING COUNT(*) > 0 ORDER BY SAL; --ORDER BY SAL 오류
하지만 ORDER BY 절은 SELECT 목록에 나타나지 않은 문자형 항목 포함될 수 있음
SELECT EMPNO, ENMAE FROM EMP ORDER BY MGR;
단, SELECT DISTINCT를 지정**, GROUP BY절**, SELECT 문에 UNION이 있으면 열 정의가 SELECT 목록에 표시되어야 함.