SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
with tbl as ( SELECT level as id from dual CONNECT BY level <= 5 union all SELECT 7 as id from dual union all SELECT 10 as id from dual ) select id, lag_id, lead_id from ( select id, lag(id) over (order by id) as lag_id, lead(id) over (order by id) as lead_id, row_number() over (order by id) as row_number_id from tbl ) --where id+1 <> next_id
Stuck with a problem? Got Error? Ask ChatGPT!
Copy Clear