how to create query ??????????

i have a table with following data
qty start_no end_no

1     1       100
1     101     200
1     201     300
1     5001    5100
1     7001    7100
1     7101    7200

i used query like
select sum(qty),min(start_no),max(end_no) from <table_name>;

it show
6 1 7200

BUT I WANT
3 1 300
1 5001 5100
2 7001 7200

PLZ HELP ME????????????????

THANKS A LOT
kuljeet pal singh Received on Fri Jan 16 2004 - 10:36:30 CET