摘要：for xml path 用法 for xml path sqlserver用法示例 创建表 use dbo; IF object_id('hobby') is not null drop table hobby; create table hobby(id int, name varchar(50 阅读全文

摘要：row_number() over(partition by... order by...)分组聚合排序 ROW_NUMBER() OVER( [PARTITION BY column_1, column_2,…] [ORDER BY column_3,column_4,…] [desc/asc] 阅读全文