SQL中遇到的实例
1.select 'TOP'+CAST(ROW_NUMBER() OVER (ORDER BY [业务量] DESC) as VARCHAR(20)) as 热门事项 ,t.事项名称 as 事项名称,t.业务量 as 业务量 from (select top 5 [JITEMNAME] as 事项名称,count([JITEMNAME]) as 业务量 from [X行政审批_P票号明细] g...
原创
2020-01-03 10:08:10 ·
203 阅读 ·
0 评论