|
|
|
Supreme Being
Group: Forum Members
Last Login: 10/7/2008 6:20:30 PM
Posts: 136,
Visits: 11
|
|
BS,
Try this
SELECT
MAX(CASE WHEN CNT =1 THEN val ELSE ' ' END ) ||
MAX(CASE WHEN CNT =2 THEN ',' || val ELSE ' ' END ) ||
MAX(CASE WHEN CNT =3 THEN ',' || val ELSE ' ' END ) ||
MAX(CASE WHEN CNT =4 THEN ',' || val ELSE ' ' END )
FROM
(
SELECT
val
,ROW_NUMBER() OVER(ORDER BY val) AS CNT
FROM SHARED.TEST
GROUP BY 1) t;
Values considered
sno val
1 USA
2 NYK
3 HKG
4 HKG
Result HKG,NYK,USA
Thanks,
Vinay Bagare
|
|
|
|