[mysql] 查看字段重复次数

小涛 2026-11-16 08:14:43 1683

代码

SELECT lj, count(*) as num FROM lj GROUP BY lj HAVING count(*)>=1;
点赞 0