T-SQL » Functions » COUNT
- Syntax:
-
SELECT COUNT ( field ) [ AS expression ]
FROM table
[ WHERE criteria ]
[ GROUP BY grouping_expression ]
[ HAVING criteria ] - field
- The name of the column on which the values are to be counted.
- expression
- The name to be displayed for the resulting count.
- table
- The name of the table the information is being retrieved from.
- criteria
- The condition(s) that dictate which rows are to be counted.
- grouping_expression
- An optional parameter that specifies a set of columns on which to group matching data.
The COUNT function simply counts how many values are in a field.
Values which are NULL are included in the counting. If the field is just an empty set, COUNT returns zero.
Examples
Code:
SELECT COUNT(Patients) AS PatientCount
FROM MediCarePatients
WHERE Date = '06/26/2000';
Output:
PatientCount 34
Explanation:
This code finds the number of MediCare patients that were in the hospital on June 26, 2000 and stores that number into 'PatientCount'.
Note: The date format in SQL is: 'mm/dd/yyyy'.
Language(s):
MS SQL Server
See Also:
