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
2 100000-110000
2 140000-140000
2 170000-180000
2 200000-200000
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
2 100000-110000
2 140000-140000
2 170000-180000
2 200000-200000
Comment