問題詳情
31 欲列出資料庫中每個產品的名稱（Name）和價格（Price），並依價格由低至高排序。根據 SQL 語法下列那一個指令之陳述正確？
(A)SELECT Name, Price FROM Product ORDER BY Price ASC
(B)SELECT Name, TOP Price FROM Product
(C)SELECT Name, Price FROM Product ORDER BY Price DESC
(D)SELECT Name, BOTTOM Price FROM Product
參考答案
答案：A
難度：簡單0.789474
統計：A(30),B(2),C(6),D(0),E(0)