复杂sql

   sql groupby 分组合并字符串

          select Name ,Opt= stuff((select '/'+ Opt from [test]. [dbo].[Test2] where a.name =name for xml path( '')),1 ,1, '') from [test] .[dbo]. [Test2] a

              group by Name

 

 

   sql server查询分组排序 

 

  SELECT ID , [YEAR] , NAME , NUM , ROW_NUMBER () OVER ( PARTITION BY [YEAR] ORDER BY Num ) AS ORDERER

from  test

 

 

转载于:https://www.cnblogs.com/xiaoye2015/p/7056207.html