SQL 문제 34 - Not Boring Movies LeetCode 620 Not Boring Movies 풀이 -- ORACLE, MYSQL SELECT ID , MOVIE , DESCRIPTION , RATING FROM CINEMA WHERE MOD(ID,2) = 1 AND DESCRIPTION != 'boring' ORDER BY RATING DESC; -- MSSQL SELECT ID , MOVIE , DESCRIPTION , RATING FROM CINEMA WHERE ID % 2 = 1 AND DESCRIPTION != 'boring' ORDER BY RATING DESC; - MSSQL에서 나머지를 구하는데 MOD함수가 먹히지 않고 '%' 연산자를 통해 나머지를 구한다. * 출처 Level up your coding skills and quickly land a job. This is the best place to expand your knowledge and ge...
#NotBoringMovies_LeetCode620
#SQL
#SQL_LeetCode620
#SQL_NotBoringMovies
#SQL_NotBoringMovies_LeetCode620
원문링크 : SQL 문제 34 - Not Boring Movies LeetCode 620