What is the result of COUNT(*) on a table with 5 rows where 2 rows have NULL in a column?

SQL Data Analyst Easy

SQL Data Analyst — Easy

What is the result of COUNT(*) on a table with 5 rows where 2 rows have NULL in a column?

Key points

  • COUNT(*) includes rows with NULL values.
  • The function counts all rows in the table.
  • NULL values are also considered in the count.

Ready to go further?

Start full exam Practice more questions

Related questions