Course Process
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