SQL常用脚本大全.docxVIP

SQL常用脚本大全(白金版) 导读：作为一名数据人，在工作中有许多比较常用的SQL脚本，今天也整理总结出来分享给大家，希望能有所帮助。 1、行转列的用法PIVOT CREATE?table?test(id?int,name?nvarchar(20),quarter?int,number?int)insert?into?test?values(1,N苹果,1,1000)insert?into?test?values(1,N苹果,2,2000)insert?into?test?values(1,N苹果,3,4000)insert?into?test?values(1,N苹果,4,5000)insert?into?test?values(2,N梨子,1,3000)insert?into?test?values(2,N梨子,2,3500)insert?into?test?values(2,N梨子,3,4200)insert?into?test?values(2,N梨子,4,5500)select?*?from?test 结果： select?ID,NAME,[1]?as?一季度,[2]?as?二季度,[3]?as?三季度,[4]?as?四季度fromtestpivot(sum(number)for?quarter?in([1],[2],[3],[4