search

Home >Database >Mysql Tutorial >sql count不重复的记录个数_MySQL

sql count不重复的记录个数_MySQL

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB
WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOriginal
2016-06-01 13:49:311383browse

bitsCN.com

select COUNT(distinct(number)) from table

查询出来的值不重复可以使用 group by '字段名'

bitsCN.com
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：Tomcat数据库连接池的配置与使用_MySQLNext article：#实践笔记#Ubuntu配置WordPress遇到了麻烦_MySQL

Related articles

See more