I have a query which returns multiple rows for a column. Is there any way to concatenate the rows in sql statement without creating a procedure.
Here is an example
Select col1 from table1 where col2 = 'XXXX' order by col3, col4
result set is
The number of rows can vary from 0 to 10
I need to write a view which should return one row with