阿摩線上測驗
登入
阿摩線上測驗
登入
試卷名稱：111年 - 111 學士後醫學系招生考試：計算機概論與程式設計#107630
年份：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.