COUNT - Aggregate Function

COUNT

The  COUNT() Function is used to returns the number of rows.

Syntax :-

SELECT  COUNT (column_name)

FROM table_name

WHERE conditions;

Example : Let's see how to used COUNT function in table.

Query :

SELECT  COUNT (Salary)

FROM customers

WHERE Customer_Id = 4;

Output :

Now, you can see COUNT() Function calculated number of row in the salary column .