Which aggregate function returns the number of non-NULL values in a column?

SQL Data Analyst Easy

SQL Data Analyst — Easy

Which aggregate function returns the number of non-NULL values in a column?

Key points

  • COUNT(column) counts non-NULL values in a specific column
  • COUNT(*) counts all rows, regardless of NULL values
  • SUM(column) calculates the total of numeric values in a column

Ready to go further?

Start full exam Practice more questions

Related questions