In SQL, count (*) does not take parameters and returns the total number of rows in a particular table. The difference between COUNT (*) and COUNT (ALL) is that COUNT (*) also counts NULL values and duplicates but COUNT (ALL) does count only unique and non-null values.
The following SQL query returns the total number of employees from the employee table:
SELECT COUNT (*)
FROM Employee;
If you want to learn SQL from Industry experts then register for this best SQL courses by Intellipaat that provides Instructor-led training, hands-on experience, and certification
Back