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
'컴퓨터' 카테고리의 다른 글
| [SQL] SUBSTR (0) | 2024.02.15 |
|---|---|
| [SQL] DISTINCT (0) | 2024.02.15 |
| [SQL] SELECT, FROM, WHERE (0) | 2024.02.15 |