試題詳解

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