COUNT Function

The COUNT() function returns the number of rows that matches a specified criterion.

Syntax:

SELECT COUNT(column_name)
FROM table_name
WHERE condition;

Query:

SELECT count(emp_no) FROM `employees`

Output:

Tester Usage Tips:

• Validate number of records from UI to Database