【mysql】查看字段重复次数

小涛 1 年前 1378

代码

SELECT lj, count(*) as num FROM lj GROUP BY lj HAVING count(*)>=1;
点赞 0
手机扫码阅读

微信或手机浏览器扫一扫,随时随地随心阅读与分享