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