河南成教 / 数据库应用1
正确率：100%
3、现有书目表book，包含字段：price (float); 现在查询一条书价最高的书目的详细信息，以下语句正确的是 （分数：3 分）
A. select top 1 * from book order by price asc
B. select top 1 * from book order by price desc
C. select top 1 * from book where price= (select max (price)from book)
D. select top 1 * from book where price= max(price)
A. select top 1 * from book order by price asc
B. select top 1 * from book order by price desc
C. select top 1 * from book where price= (select max (price)from book)
D. select top 1 * from book where price= max(price)
参考答案：
佳题速递：