By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,379 Members | 1,380 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,379 IT Pros & Developers. It's quick & easy.

Result Set In A Range Of Numbers

P: 2
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
Apr 8 '08 #1
Share this Question
Share on Google+
1 Reply


ck9663
Expert 2.5K+
P: 2,878
More details please.

-- CK
Apr 9 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.