如何倒序取出六条记录,好象order by和rownum不能同时写呀

[cmjust]

倒序取出六条记录,但好象用order by和rownum不能实现我要求,该怎么写呢

[snowy_howe]

use 分析函数

[ORARichard]

select * from (select rownum no,col1,col2,...,coln from tbname group by col1,col2,...coln)
where no>(select count(0)-6 from tbname);

[cmjust]

怎么写呀,帮我写一下好吗

[epbon]

select * from (select rownum no,col1,col2,...,coln from tbname
where no>(select count(0)-6 from tbname) order by no desc;
ORARichard(没钱的日子好难过啊)兄可能忘了加order by :)

[epbon]

select * from (select rownum no,col1,col2,...,coln from tbname)
where no>(select count(0)-6 from tbname) order by no desc;
把)给弄丢了，不好意思！

[ATGC]

SQL> select * from bb;

ID
----------
10
1
8
6
15
150
16
19

已选择8行。

SQL> select id from(
2 SELECT id,
3 row_number()
4 OVER (PARTITION BY 1
5 ORDER BY id desc NULLS LAST) top_6
6 FROM bb) b
7 where b.top_6<=6;

ID
----------
150
19
16
15
10
8

已选择6行。

[ORARichard]

楼上的提醒的好啊。

[xjliang007]

selec * from (selec * from b order by a desc) where rownum<7