要查出所有在1978 1997 2008年上映的电影的标题并以电影的编号降序输出 SQL语句为——
已帮助 人
要查出所有在1978，1997，2008年上映的电影的标题并以电影的编号降序输出，SQL语句为——
A．SELECT title FROM Movie WHERE year IN (‘1978’, ‘1997’, ‘2008’) ORDER BY mID ASC;
B．SELECT title FROM Movie WHERE year = ‘1978’ OR year = ‘1997’ OR year = ‘2008’ ORDER BY mID ASC;
C．SELECT title FROM Movie WHERE year IN (‘1978’, ‘1997’, ‘2008’) ORDER BY mID DESC;
D．SELECT title FROM Movie WHERE year = ‘1978’ AND year = ‘1997’ AND year = ‘2008’ ORDER BY mID DESC;
回答
共1条回复-
SELECT title FROM Movie WHERE year IN (‘1978’, ‘1997’, ‘2008’) ORDER BY mID DESC;