现有书目表book，包含字段：price (float); 现在查询一条书价最高的书

select top 1 * from book order by price asc

select top 1 * from book order by price desc

select top 1 * from book where price= (select max (price)from book)

select top 1 * from book where price= max(price)