有表记录如下:f_djh f_syybm ... ...
1420091011 0910
1420091011 0910
1420091013 0912
1420091013 0912
1420091014 0910
1420091014 0910
1420091014 0910
1420009101 0913汇总后如下:f_syybm(收银员编码) jl(笔数)
0910 2
0912 1
0913 1
1420091011 0910
1420091011 0910
1420091013 0912
1420091013 0912
1420091014 0910
1420091014 0910
1420091014 0910
1420009101 0913汇总后如下:f_syybm(收银员编码) jl(笔数)
0910 2
0912 1
0913 1
count(*)JL
from tb group by f_syybm
count(DISTINCT f_syybm )JL
from tb group by f_syybm
SELECT
F_SYYBM AS 收银员编码,SUM(F_DJH) AS 笔数
FROM TB
GROUP BY F_SYYBM
ORDER BY F_SYYBM
count(DISTINCT f_djh)JL
from tb group by f_syybm
F_SYYBM AS 收银员编码,COUNT(*) AS 笔数
FROM TB
GROUP BY F_SYYBM
ORDER BY F_SYYBM刚写错了。
from tb
group by f_syybm
select f_syybm,count(distinct f_djh) as jl
from tb
group by f_syybm