Re: SQL Question - Ranges of Sequences -

cant you do this:

select min(id) minid, max(id) maxid,description, count(id) from test_table
group by description
order by description;

Brent Douglas, ncr

Create table test_table (id number, description varchar2 (20));

*also, this is the right syntax, not insert into table tablename.....

Insert into test_table values(1,'D1');
Insert into test_table values (2,'D1');
Insert into test_table values (3,'D1');
Insert into test_table values (4,'D2');
Insert into test_table values (7,'D2');
Insert into test_table values (8,'D2');
Insert into test_table values (20,'D3');
Insert into test_table values (21,'D3');
Insert into test_table values (22,'D3');
Insert into test_table values (23,'D4');
Insert into test_table values (30,'D4');