What is the purpose of the COUNT() aggregate function?

To calculate the sum of values in a column

To find the average value of a column

To return the number of rows that match a specified criterion

To find the maximum value in a column

COUNT() is an aggregate function that counts the number of rows. COUNT(*) counts all rows, while COUNT(column) counts non-NULL values in that column.

Strengthen Your Practice with our comprehensive question bank.

Get Expert Advice for Free: Register for Your Free Consultation Now!

Full Name

Phone Number

Select Language

Select Course

Please leave this field empty.