In the table
sERIES TICKETNO STATUS
THE MIN DIFFERENCE WILL BE BETWEEN 1 ST ROW AND NEXT ROW WILL BE 10000
1 100000 0
1 100000 1
1 120000 0
1 130000 0
1 140000 0
1 150000 1
1 160000 0
1 170000 1
1 180000 0
1 190000 1
1 200000 0
CONTIUNED DEPENDS ON HOW MANY TICKETS ARE ALLOTED
...
LGBYTES
Last Activity: Oct 30 '08, 07:55 AM
Joined: Apr 8 '08
Location:
-
Need help in get the result in the format
-
Result Set In A Range Of Numbers
Id Ticketno
1 100000
1 120000
1 130000
1 140000
2 100000
2 110000
2 140000
2 170000
2 180000
2 200000
The Min Difference Will Be Between 1 St Row And Next Row Will Be 10000
From The Above Data I Need Result Set As
1 100000-100000
1 120000-140000...
No activity results to display