SQL COUNT Function - SQL Server Count() Function
The SQL COUNT() Function
- COUNT() counts how many rows meet certain conditions in a dataset or database, helping to find out the number of occurrences that fit those conditions.
Demo Database
- Here is a segment extracted from the Wikitechy table as referenced in the examples provided:
![table -Wikitechy](https://wikitechy.com/cdn/tutorials/sql/table-wikitechy.jpg)
Syntax
SELECT COUNT(column_name) FROM table_name;
- Find the overall number of products available within the Wikitechy table.
Example
SELECT COUNT(*) FROM tbl_Wikitechy;
Output
![sql-count-function](https://wikitechy.com/cdn/tutorials/sql/sql-count-function.jpg)