Retrieving range in SQLServer

[nmkishan22]

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.

[VictorN]

And what does this

1-2

mean?
Or

5-7

Is it a simple subtraction or what?

[nmkishan22]

its not minus it is the range of the ID present in the table

ex. 1 to 2 are present in table
5 to 7 are present in table
9 is present in table
11 is present in table


so tht i can populate a combobox with different ids present in table else i need to get each item from table which wil be overload. If i have range i can manipulate in my application and get all the ids from the range i retrieved from table.

[VictorN]

Unfortunately your explanation didn't make your "problem" more clear for me.
What are you going to populate in a combobox: IDs or Names?
What is wrong just to SELECT ID FROM [your table]?

[nmkishan22]

If below is my table with 2 column id and Name

id Name
---- ----------------------
1 Item1
2 Item2
5 Item5
6 Item6
7 Item7
9 Item9
11 Item11
---- -----------------------

if i write "Select Id from table" i wil get O/P like below

id
---
1
2
5
6
7
9
11
----

But i wanted to get o/p like

id
------------------
1-2
5-7
9
11
------------------

Please help me out...

[VictorN]

I think that SELECT ID FROM [your table]
+ write 5-7 line of code to find all the cases where the next record ID is not equal (the previous one + 1) would be much faster than waiting for answers how to do it only by means of SQL.

[nmkishan22]

can you please give the code to do so. My id field will take value from 0 - 9999999999 so looping wil be a problem for me

[VictorN]

No, I won't just try!
It will be a very simple exercise for you to write such a code. Then you should test how fast/slow will it work with your very big table. If too slow - then and only then you should try to improve it.

[bex_zex]

try this
SELECT * FROM tableName WHERE id IN (1,2,5,8)

[VictorN]

try this
SELECT * FROM tableName WHERE id IN (1,2,5,8)

!. Do you expect OP is still needing our help? The thread is 15 months old!

2. How your query could help the OP to get the following output

i want to get out put like below one

id
------------------
1-2
5-7
9
11
------------------