17,140
社区成员
发帖
与我相关
我的任务
分享查询价格最高的图书，输出书名及作者,SQL怎么写？
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));
...全文
请发表友善的回复…
发表回复
jiajian008 2006-05-31
- 打赏
- 举报
我的效率最高
jiajian008 2006-05-31
- 打赏
- 举报
select bname,author from
(select *
from books
order by price desc
)where rownum<=1;
(select *
from books
order by price desc
)where rownum<=1;
超叔csdn 2006-05-30
- 打赏
- 举报
昏
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 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;
xjqqxjqq 2006-05-30
- 打赏
- 举报
SELECT MAX(price),bname,author from books GROUP BY bname,author
chshhxyz012 2006-05-30
- 打赏
- 举报
select bname,author from books
where max(price);
where max(price);
