Bright Tutorials Bright Tutorials
CBSE Class 12 Informatics Practices Question 28 of 90

Querying Using SQL — Question 6

Back to all questions
6
Question

Question 6

Which SQL function is used to count the number of rows in a SQL query ?

  1. COUNT()
  2. NUMBER()
  3. SUM()
  4. COUNT(*)
Answer

COUNT(*)

Reason — The SQL function COUNT(*) is used to count the number of rows in an SQL query, including duplicates and rows with NULL values.