阿摩線上測驗
登入
阿摩線上測驗
登入
試卷名稱：111年 - 111 學士後醫學系招生考試試題：計算機概論與程式設計#137107
年份：111年
科目：【阿摩】未分類題庫
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.