I have a table (myTable) with a single column (myColumn). There are several rows with numbers (integers only) already sorted ascending. What steps would I take to write a SQL statement the would separate consecutive numbers with a hyphen and non consecutive
numbers with a comma?
Would have output of: 1-3,5-6,8
View Complete Post