请教高手~~,简单的SQL语句

[byimbba]

我要查询 数据库 中 ,价格最贵的那本书的名称.
select book.name ,max(book.price) from bookk group by book.name
得出得数据不是我想要得,这该怎么写啊??

[xq02]

select a.name,a.price from bookk a where not exists(select * from bookk where price>a.price)

[xeqtr1982]

你这样应该可以阿

select name from book a where not exists(select 1 from book where name=a.name price>a.price)

[xeqtr1982]

select name from book a where not exists(select 1 from book where name=a.name and price>a.price)

--少打了个and

[billpu]

select top 1 name from book order by price desc

[godfather_wang]

select name,maxprice from bookk a,(select max(book.price) as maxprice from bookk ) b
where a.price=b.maxprice

[CNNO01]

select name,price from book where price in(select max(price) from book)