24. Refer to Table 3 and Table 4, please indicate the CORRECT SQL statement that can output as
depicted in Table 5.
(A) SELECT * FROM movies
(B) SELECT TOP 1 movies.movie, actors.name FROM movies INNER JOIN
actors ON movies.actor = actors.id ORDER BY actors.salary DESC
(C) SELECT movies.movie, actors.name FROM movies INNER JOIN actors
ON 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.
答案:登入後查看
統計: 尚無統計資料
統計: 尚無統計資料