Find unique and sorted field value
Hi,
A column named input contains the following values in a table.The column Transformed output contains unique value of the column named input and in sorted manner.
Sample output is present in column Transformed Output.
| Input | Transformed output |
|---|---|
| G25,G25,G25,G25,G28,G28,G29,G25,G25 | G25,G28,G29 |
| G26,G26,G26,G26,G28,G25,G28,G29,G26,G25,G26 | G25,G26,G28,G29 |
How can be this achieve by a single sql query.
0