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
