摘要：SELECT *,FROM Product WHERE ID IN ( 7, 6, 8 ) ORDER BY CHARINDEX(',' + CONVERT(VARCHAR(10), ID) + ',' + '7,6,8')
阅读全文
posted @ 2019-03-18 09:57
随笔分类 - sql server
摘要：select * from a pivot(sum([总业绩]) for 周期 in ([1月],[2月],[3月],[4月])) as b
阅读全文
posted @ 2018-08-14 09:30
摘要：1、聚合sum avg max min等 select id,sum(销量) over() as 销量 from 业绩表 2、排序row_number()、dense_rank()、rank() --select *,row_number() over(partition by id order b
阅读全文
posted @ 2018-08-14 09:20
浙公网安备 33010602011771号