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

Post a Comment

0 Comments