-
June 30th, 2010, 12:22 AM
#1
Retrieving range in SQLServer
Hi All
Can any one let me know how can i get range of a particular column from database
Eg:
if i have a below table in data base
id Name
---------------------------
1 Item1
2 Item2
5 Item5
6 Item6
7 Item7
9 Item9
11 Item11
---------------------------
i want to get out put like below one
id
------------------
1-2
5-7
9
11
------------------
I have heard it is possible but not sure how to do can any one please help me.
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|