SQL - Select Count

The SELECT COUNT statement in SQL is used to count the number of rows that match a specific condition in a table. It returns a single value, which represents the count of rows that satisfy the given condition. 

SELECT COUNT(column_name)
FROM table_name
WHERE condition;

If you want to count the number of employees in the "Sales" department, you can use the SELECT COUNT statement like this:

SELECT COUNT(*) 
FROM employees 
WHERE department = 'Sales';

You can also use the SELECT COUNT statement without a specific condition to count all the rows in a table. For example:

SELECT COUNT(*)
FROM employees;

This query will return the total number of rows in the employees table.

Note that the SELECT COUNT statement can also be used with other aggregate functions, such as SUM, AVG, MIN, or MAX, to perform calculations on the selected rows.