顾名思义,这个COUNT用于汇总计数的。

    这个COUNT是聚合函数的一员,使用示例如下:

    1. SELECT COUNT(*) FROM YourTableName WHERE Deleted = 0;

    或者

    SELECT Name, COUNT(*) AS TotalCount FROM YourTableName WHERE Deleted = 0 GROUP BY Name ORDER BY Name;