随笔分类 -  sql

常用sql语句
摘要：1.列转字符串 select stuff(( select ','+name from Student for xml path('')),1,1,'') as name 2.按组排序号 select deptId,empname, ROW_NUMBER() over(partition by de 阅读全文
posted @ 2022-05-31 16:44 0Behavior 阅读(48) 评论(0) 推荐(0)