使用oracle的sql语句实现,怎么做?
N1
4 5 6 7 9 10 13 14 15
要得到如下结果
4 9 13
select case when leag(n1,1,0) over(order by n1) - n1 >1then leag(n1,1,0) over(order by n1)when rowid = (select min(rowid) from tablename)then n1endfrom tablename;
未测试,应该能行