SQL Count Function With Example

.

Count() Function In SQL - How To use the Count Function in SQL?

Count Function in SQL with Example

Count() 

The count Function in SQL Is Used To Just Count The Number Of rows in a Table.

IN SQL COUNT() function IS Used To return the number of rows that matches a specified criteria

Syntax of Count Function

The Basic Syntax for Count Function is As follows

SELECT COUNT(column_name) FROM table_name WHERE condition;

Example of Count Function

A basic Example of the count function is given below.

SELECT COUNT(RollNo) FROM Student;

Hope !!! The above Tutorial on the Count function in SQL with Examples is helpful for you...

Team,

QA acharya