21. 假設有一個學生資料表 students,包含 name 和 score 欄位,想要找出成績最高的學 生,哪一個 SQL 查詢是正確的?
(A) SELECT name FROM students ORDER BY score ASC LIMIT 1;
(B) SELECT name FROM students WHERE score = MAX(score);
(C) SELECT name FROM students ORDER BY score DESC LIMIT 1;
(D) SELECT MAX(name) FROM students;
答案:登入後查看
統計: A(0), B(2), C(4), D(0), E(0) #3494456
統計: A(0), B(2), C(4), D(0), E(0) #3494456