COUNT()函数返回匹配指定条件的行数。
SQL COUNT(column_name)语法
COUNT(column_name)函数返回指定列的值的数目(NULL 不计入):
SELECT COUNT(column_name) FROM table_name;
SQL COUNT(*) 语法
COUNT(*)函数返回表中的记录数:
SELECT COUNT(*) FROM table_name;
SQL COUNT(DISTINCT column_name)语法
COUNT(DISTINCT column_name)函数返回指定的不同值的数目:
SELECT COUNT(DISTINCT column_name) FROM table_name;
演示数据库
示例
计算"access_log"表中"site_id"=3的总访问量:
SELECT COUNT(count) AS nums FROM access_log
WHERE site_id=3;
计算"access_log"表中的总记录数:
SELECT COUNT(*) AS nums FROM access_log;
计算"access_log"表中不同site_id的记录数:
SELECT COUNT(DISTINCT site_id) AS nums FROM access_log;
参考:
https://www.yuque.com/docs/share/de1aa90c-18bd-4457-8d2c-703c5a583108