A friday SQL teaser! 11.2.03.
I have a table with indicator and start, end ranges. I need an SQL to return ranges that are not excluded.
create table k_test (indicator varchar2(10),start_val number, end_val number);
insert into k_test values('INCLUDE',000,999);
insert into k_test values('EXCLUDE',000,503);
insert into k_test values('EXCLUDE',507,511);
insert into k_test values('EXCLUDE',514,999);
A select statement please to return the ranges that are "open", i.e. not excluded.
504
505
506
512
513
I can manage this in PL/SQL, keen to know a clever way in SQL.