728x90
select *
from cinema
where id % 2 = 1 and description != "boring"
order by rating descstring, modulo(%) 파이썬이랑 똑같이 사용
728x90
'SQL' 카테고리의 다른 글
| [LeetCode] Reformat Department Table (sum, case, when, then) (0) | 2021.04.09 |
|---|---|
| [LeetCode] Swap Salary (update, ENUM, SET, CASE, IF) (0) | 2021.04.09 |
| [LeetCode] Classes More Than 5 Students (group by, having, count, distinct) (0) | 2021.04.09 |
| [LeetCode] Rising Temperature (interval, self join) (0) | 2021.04.09 |
| [LeetCode] Delete Duplicate Emails (delete, self join, and) (0) | 2021.04.09 |
댓글