試題詳解

7. 若有一個 SQL 表格 students 包含姓名(name)、座號(sid)、成績(score)三個欄位，以下哪一個 SQL query 可以讓這個表格依照成績從高到低排列，而 同分者依座號由低到高排列？
(A) SELECT*FROM students GROUP BY score ORDER BY sid
(B) SELECT*FROM students ORDER BY score DESC GROUP BY sid
(C) SELECT*FROM students ORDER BY score DESC , sid
(D) SELECT*FROM (SELECT*FROM students ORDER BY score DESC) s1 GROUP BY sid ASC