Hi,
Try like as follows,
SELECT ROW_NUMBER() OVER(PARTITION BY M.id, ORDER BY M.suborder) 'RowNo',
M.id, M.suborder, STUFF((SELECT ','+suborder AS text()
FROM table_name
WHERE ROW_NUMBER() OVER(PARTITION BY id, ORDER BY suborder) <> 1
AND id=M.ID FOR XML PATH(''))),1,1,'') 'OtherSuborders'
FROM table_name M
WHERE ROW_NUMBER() OVER(PARTITION BY M.id, ORDER BY M.suborder) = 1
Regards,
GVPrabu