sql server怎么实现多条不同数据合并一条数据

这个技术叫“行转列”，不是你说的不同数据合并一条数据

SELECT SEQ_S,SEQUENCE,GRADE,RANK(CLASS) OVER(SELECT * FROM (SELECT CLASS,STANDARD_WAGE FROM TABLE) PIVOT (SUM(STANDARD_WAGE) FOR CLASS IN ('1','2','3','4','5','6','7','8','9')) FROM TABLE GROUP BY SEQ_S,SEQUENCE,GRADE;

尝试写了下不知道会不会报错，思路是先根据序列体系、体系和等级来分组最后两个字段单独开窗做行转列