실행순서 표
키워드 |
작성순서 |
실행순서 |
SELECT |
1 |
5 |
FROM |
2 |
1 |
WHERE |
3 |
2 |
GROUP BY |
4 |
3 |
HAVING |
5 |
4 |
ORDER BY |
6 |
6 |
예시 쿼리
SELECT type, COUNT(1), MAX(weight)
FROM pokemon.mypokemon
WHERE name LIKE ‘%a%’
GROUP BY type
HAVING MAX(height) > 1
ORDER BY 3;
예제 테이블은 다음 글에 있다. pokemon db
쿼리 |
실행순서 |
SELECT type, COUNT(1), MAX(weight) |
5 |
FROM pokemon.mypokemon |
1 |
WHERE name LIKE ‘%a%’ |
2 |
GROUP BY type |
3 |
HAVING MAX(height) > 1 |
4 |
ORDER BY 3; |
6 |