I have this code from another post :\[code\]SELECT bar FROM (SELECT S.subcategoryname As bar, C.CategoryName AS SortName, ROW_NUMBER() OVER (PARTITION BY C.CategoryName ORDER BY subcategoryname) As RowNum FROM category C LEFT JOIN subCategory S ON C.CategoryID = S.CategoryID UNION ALL SELECT C.CategoryName As bar, C.CategoryName AS SortName, 0 FROM category C) fooORDER BY foo.SortName, RowNum\[/code\]It works, but how can I retrieve more than just \[code\]categoryName\[/code\] and \[code\]subCategoryName\[/code\]. Is there a way to retrieve data from all columns?
my code:\[code\]select * from (select s.titlu_subcerinta as bar,c.titlu_Cerinta As SortName, ROW_NUMBER() over(partition by c.titlu_Cerinta order by titlu_subcerinta) as RowNumfrom cerinteProiect c left join subcerinteProiect s on c.id_cerinta = s.id_cerintaUNION ALLselect c.titlu_Cerinta As bar, c.titlu_Cerinta As SortName,0from cerinteProiect c)fooorder byfoo.SortName,RowNum\[/code\]