How to use count in SQL?

Question

Can anyone tell me how to use count in SQL?

Answer 1

Count() function is used to count the number of rows that matches the specific condition. Here is a syntax to use Count() function in SQL:

SELECT COUNT (ColumnName)
FROM TableName
WHERE condition(s);

For example, if you wish to find the number of employees whose salary is less than 25000

SELECT COUNT(*)

FROM Employee

where salary < 25000

If you wish to learn SQL, then sign up for this SQL course by Intellipaat that comes with instructor-led training and hands-on experience.