mysql 怎么统计同一字段不重复值的数量

SELECT city_name, title, COUNT(*) FROM tuan_info GROUP BY city_name, title HAVING COUNT(*) >1
mysql 怎么统计同一字段不重复值的数量
select distinct(字段名字) from table2017-03-14
SELECT city_name, title, COUNT(*) FROM tuan_info GROUP BY city_name, title HAVING COUNT(*) >12017-03-14
mengvlog 阅读 7 次 更新于 2025-07-20 01:54:42 我来答关注问题0
檬味博客在线解答立即免费咨询

mySQL相关话题

Copyright © 2023 WWW.MENGVLOG.COM - 檬味博客
返回顶部