题目内容
(请给出正确答案)
[单选题]
在SQL Server数据库中,有goods(商品)表,包含字段:GID(编号)、Gname(商品名称)、price(价格)现查找所有商品中价格最高的前5件商品信息,下列SQL语句正确的是()
A.select top 5 from goods order by price desc
B.select top 5 * from goods group by price desc
C.select top 5 * from goods group by price
D.select top 5 * from goods order by price desc
查看答案
如果结果不匹配,请 联系老师 获取答案