Correct Answer: count(distinct)
Explanation:
Note: This Question is unanswered, help us to find answer for this one
MySQL Skill Assessment
Your Skill Level: Poor
Retake Quizzes to improve it
More MySQL MCQ Questions
Which is not a Spatial Data Type?
Which are true concerning indexes?
Assume, you have a table inventory(id int, description text, price int). How can you change the type of price from int to decimal(10,2)?
In a WAMP environment, what is the correct way to permanently change the largest possible packet that can be transmitted to or from a MySQL server?
Given two tables, t1 and t2, the join condition 't1.t2_id = t2.id' how do you get rows from t1 that have NO counterparts in t2?
For the COERCIBILITYO function. what does coercibility value of 0 mean?
Result of the following two queries? 1. SELECT POW(2.2): 2. SELECT POWER(2.3):
Which operators are supported by boolean full-text search?
Invalid year data type values are converted to which of the following?
In MySQL 5.6.5. how many bytes are required to store the DATETIME data type?