컴퓨터
[SQL] 내림차순 DESC, 오름차순 ASC
귀차니즘마왕
2024. 2. 15. 17:46
SELECT *
FROM ‘movie_data.movies’
ORDER BY Release_Date
SELECT *
FROM ‘movie_data.movies’
ORDER BY Release_Date DESC
SELECT *
FROM ‘movie_data.movies’
WHERE Genre = “Comedy”
ORDER BY Release_Date DESC
SELECT *
FROM ‘movie_data.movies’
WHERE Genre = “Comedy”
ORDER BY Release_Date DESC
SELECT *
FROM ‘movie_data.movies’
WHERE Genre = “Comedy”
AND Revenue > 300000000
ORDER BY Release_Date DESC
수익이 3억이상인 코미디 영화 개봉일 기준삼아 내림차순(DESC)
기본값은 오름차순(ASC)
* SORT 구문에서 오름차순은 TRUE 내림차순은 FALSE