select top 5 zhineng,count(zhineng) as vcount,count(*) as counts from tblemploy group by zhineng order by 2 desczhineng 发布次数
============================================未选择== 97
销售人员 2
物流/仓储 2
计算机软件 2
广告 1
取前五条发布次数最多的岗位类型,在这五条之外的 次数,怎么求,还有在“zhineng” 这一列怎么 定义一列“其它”列, 本人现在在做统计,忘高手指教
============================================未选择== 97
销售人员 2
物流/仓储 2
计算机软件 2
广告 1
取前五条发布次数最多的岗位类型,在这五条之外的 次数,怎么求,还有在“zhineng” 这一列怎么 定义一列“其它”列, 本人现在在做统计,忘高手指教
。
============================================未选择== 97
销售人员 2
物流/仓储 2
计算机软件 2
广告 1
其它 (总数-97-2-2-2-1)
哪位高手帮帮我啊。!!!!!!!!!!
Select
*
From (
Select
*
From (
Select Top 5
zhineng,
Count(*) As 发布次数
From tblemploy Group By zhineng Order By 发布次数 Desc
) A
Union
Select '其它',Count(*)-(Select Sum(发布次数) From (
Select Top 5 Count(1) As 发布次数 From tblemploy Group By zhineng Order By 发布次数 Desc
) B)
From tblemploy
)T
Order By 发布次数 Desc
Select
*
From (
Select Top 5
zhineng,
Count(*) As 发布次数
From tblemploy Group By zhineng Order By 发布次数 Desc
) A
Union
Select '其它',Count(*)-(Select Sum(发布次数) From (
Select Top 5 Count(1) As 发布次数
From tblemploy Group By zhineng Order By 发布次数 Desc
) B)
From tblemploy