COUNT

SQL Count Function

The COUNT function returns the number of items in a group. COUNT function returns an int data type value.

SQL COUNT syntax

SELECT COUNT(*)
FROM table_name;

Training_Course

IDNAMEDURATIONPRICE
1SQL5200
2T-SQL7700
3MySQL5600
4PL/SQL7800
5PostgreSQL6500

Example

select COUNT(*) 
from Training_Course 
where PRICE > 500;

Results

3