Which SQL statement is used to return only different values?
Correct Answer: SELECT 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
Valid modes of parameters in stored routines?
Which will truncate all tables in a MySQL database?
Which are valid MySQL functions?
Valid types of table present in MySQL?
Whichaare true for user-defined variables?
What is true regarding the TIMESTAMP data type?
Name of the utility used to extract NDB configuration information?
What is true regarding the SET data type?
Which query will display data from the Pers table relating to Analyst, Clerk and Salesman who joined between 1/1/2005 and 1/2/2005 ? Which query will display data from the Pers table relating to Analysts, Clerks and Salesmen who joined between 1/1/2005 and 1/2/2005 ?
What will happen if you write the following statement on the MySQL prompt? SELECT NOW();