当前位置：网站首页>Leetcode: 620. interesting movies

Leetcode: 620. interesting movies

2022-07-22 19:09:00 【A master of East and West】

The original title is ：https://leetcode-cn.com/problems/not-boring-movies/

# Write your MySQL query statement below
select id, movie, description, rating
from cinema
where description <> 'boring' and id&1
order by rating desc;

<> and != It's the same
and id&1 It is used to judge odd numbers
It can be used where mod(id, 2) = 1 To judge id Is it odd , But the efficiency will be a little lower

原网站

版权声明
本文为[A master of East and West]所创，转载请带上原文链接，感谢
https://yzsam.com/2022/203/202207220911019211.html