query to display a row data as column

Question

I need a query to execute record of row as columns, eg: row holds data as '101,102,103,104'.

Result should be:

101
102
103
104

Answer 1

you can check switching-rows-and-columns-in-sql