Separate numbers in SQL (Show Max & Min)

Oct 3 2012 7:17 AM

Hi All,

I have numbers Say from 1 to 100. (1,2,3,..25,50,51,52.......100)
In that 25 to 50 numbers are missing.

Then i have to display that record in foll format.

1-25,51-100

Can we show this in Sql.

plz give me sql query