17,088
社区成员
发帖
与我相关
我的任务
分享
select class,seqnum,highpoint,lowpoint,name
from(select class,seqnum,highpoint,lowpoint,name,lag(lowpoint,1,111)over (order by class,seqnum) low1
from table order by class,seqnum)
where highpoint<low1 order by class,name;
select class,seqnum,highpoint,lowpoint,name
from(select class,seqnum,highpoint,lowpoint,name,lag(lowpoint,1,0)over (order by class,seqnum) low1
from table order by class,seqnum)
where highpoint<low1 order by class,name;
select class,seqnum,highpoint,lowpoint,name
from(select class,seqnum,highpoint,lowpoint,name,lag(lowpoint,1,0)over (order by class,seqnum) low1
from table)
where highpoint<low1 order by class,name;