코딩하렴

SELECT문의 실행순서

by 으렴


1. FROM

2. WHERE

3. GROUP BY

4. HAVING

5. SELECT

6. ORDER BY


SELECT USERNAME       //5
FROM MEMBER //1
WHERE MEMBERNO=10 //2
GROUP BY USERNAME //3
HAVING COUNT(*)>=1 //4
ORDER BY MEMBERNAME; //6


사이트의 정보

코딩하렴

으렴

활동하기