How can you count a specific column in SQL?

6 months ago

1 minute

You can use the COUNT function in SQL to count a specific column. The COUNT function is used to calculate the number of rows with non-NULL values in the specified column.

For example, suppose there is a table named students, which has a column called age storing the age of the students. To count the age column, you can use the following SQL statement:

SELECT COUNT(age) as age_count
FROM students;

The SQL statement above will return the number of rows with non-NULL values in the age column and store the result in a column named age_count. You can modify the SQL statement according to your needs, such as adding a WHERE clause to filter rows based on specific conditions.