create table books
(bno varchar2(10),
bname varchar2(20),
author varchar2(10),
price number(4,2),
quantity number(6));
(bno varchar2(10),
bname varchar2(20),
author varchar2(10),
price number(4,2),
quantity number(6));
where max(price);
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;
(select *
from books
order by price desc
)where rownum<=1;