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

Count()Syntax

The Basic Syntax for Count Function is As follows

SELECT COUNT(column_name) FROM table_name WHERE condition;

EXAMPLE

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

Tags:

Count Function with Example, How to count record from table , SQL Count

.