Q. Which SQL function returns the number of distinct values?

A
COUNT()
B
COUNT(DISTINCT)
C
SUM()
D
AVG()
Solution:

COUNT(DISTINCT) returns the number of unique values in a specified column.

Entri PDF Icon

Get Question Bank

Strengthen Your Practice with our comprehensive question bank.

Entri Contact Image

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