select name ,name1 from (select name,lead(name,1,null)over(order by name asc) name1 from table) where name1 is not null
楼主的数据abcdefg只是举的测试数据,没有规律的,用ascii不行。Oracle分析函数lead取当前行对应的下一行记录 SELECT * FROM (SELECT NAME ,lead(name)over(ORDER BY name) name1 FROM a ) WHERE name1 IS NOT null;
直接: select name,lead(name,2) over(order by name) name1 from a
from table) where name1 is not null
楼主的数据abcdefg只是举的测试数据,没有规律的,用ascii不行。Oracle分析函数lead取当前行对应的下一行记录
SELECT * FROM (SELECT NAME ,lead(name)over(ORDER BY name) name1 FROM a )
WHERE name1 IS NOT null;
select name,lead(name,2) over(order by name) name1 from a