首页
Java
登录
6mi
u
盘
搜
搜 索
Java
leetcode 620. Not Boring Movies(SQL,查询排序)38
leetcode 620. Not Boring Movies(SQL,查询排序)38
xiaoxiao
2021-02-28
27
贴原题:
解析: 本题是要用从ciema表中选出id为奇数,并且description不为’boring’的电影,并按照rating降序排序输出。
贴SQL代码:
# Write your MySQL query statement below
SELECT
*
FROM
cinema
WHERE
id%
2
=
1
AND
description!=
'boring'
ORDER
BY
rating
DESC
;
转载请注明原文地址: https://www.6miu.com/read-1700272.html
技术
最新回复
(
0
)