查询价格最高的图书，输出书名及作者,SQL怎么写？

[tedagov328281]

create table books
(bno varchar2(10),
bname varchar2(20),
author varchar2(10),
price number(4,2),
quantity number(6));

[chshhxyz012]

select bname,author from books
where max(price);

[xjqqxjqq]

SELECT MAX(price),bname,author from books GROUP BY bname,author

[超叔csdn]

昏
select bname,author from books
where price=(select max(price) from books);

select first_value(bname)over(order by price desc),frist_value(author)over(order by price desc)
from books;

[jiajian008]

select bname,author from
(select *
from books
order by price desc
)where rownum<=1;

[jiajian008]

我的效率最高