表 a
编号 UID WNO
1 admin 001
2 admin 002
3 admin 003
4 admin 001
5 admin 002
6 HYJ 002
输出ADMIN 结果
WNO COUNT
001 2
002 2
003 1
编号 UID WNO
1 admin 001
2 admin 002
3 admin 003
4 admin 001
5 admin 002
6 HYJ 002
输出ADMIN 结果
WNO COUNT
001 2
002 2
003 1
WHERE UID = 'ADMIN'
group by wno
select WNO,count(WNO) as COUNT from a where UID="admin" group by WNO