Database MCQS - QUESTION DETAILS

In MySQL, what is the purpose of the COUNT() function with DISTINCT?
A. Count all rows
B. Count only distinct rows
C. Count rows based on a condition
D. Count rows in a specific column

'COUNT(DISTINCT)' is used to count only distinct rows in MySQL.

Similar Questions

What is the maximum length of the VARCHAR data type in MySQL?






In MySQL, which type of index allows only unique values and nulls are considered distinct?






What is the purpose of the SQL ORDER BY clause?






Which Oracle statement is used to grant execute permissions on a stored procedure?






What does the SQL INNER JOIN clause do?






What is the purpose of the SQL Server CROSS APPLY operator?






Which SQL Server statement is used to create a stored procedure?






Which SQL function is used to find the highest value in a column?






What is the purpose of the SQL LIMIT clause?






In Oracle, what is the purpose of the INSTR() function?