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.