oracle语句 ( 积分: 50 )

S

say-rise

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-11-08

• #1

BL_NO CNT_NO
A1 AAAU1111111
A2 AAAU1111111
bs wfe
ss efi
fwf fefwf
-------------------------------------------------------
怎么取出后三行的BL_NO（CNT_NO相同的不取）

 

P

power255

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-11-08

• #2

把BL_NO按反序查询(要有Distinct),然后只查前三条

 

S

say-rise

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-11-08

• #3

这只是一个假设，数据还有很多

 

H

hongfeng0727

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-11-08

• #4

select b.xx,b.xxx from
(select a.rownum,a.xxx,a.... from xx_tab a) b
order by b.rownum

再取唯一值就是了。

 

H

hongfeng0727

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-11-08

• #5

忘了再加以倒序排列

 

P

power255

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-11-09

• #6

TO:say-rise你是不是只要CNT_NO不相同的数据？？
假设表名为Tmp2007110900002
select A.*
from (select tmp.*,
(select sum(1)
from Tmp2007110900002 tmp2
where tmp2.cnt_no = tmp.cnt_no) num
from Tmp2007110900002 tmp) A
where num = 1