Separate numbers in SQL (Show Max & Min)
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