問題詳情

24. Refer to Table 3 and Table 4, please indicate the CORRECT SQL statement that can output asdepicted in Table 5.


(A) SELECT * FROM movies
(B) SELECT TOP 1 movies.movie, actors.name FROM movies INNER JOINactors ON movies.actor = actors.id ORDER BY actors.salary DESC
(C) SELECT movies.movie, actors.name FROM movies INNER JOIN actorsON movies.actor = actors.id ORDER BY actors.salary
(D) All of the above can output the same results, as shown in Table 5.
(E) None of the above can output the same results, as shown in Table 5.

參考答案

答案：B
難度：計算中-1
書單：沒有書單，新增