V

Vishal Gupta • 7.73K Points
Tutor III 

Q. Which clause is used to group rows by common column values?

  • (A) SELECT
  • (B) GROUP BY
  • (C) ORDER BY
  • (D) WHERE

Correct answer: Option(B)

MySQL Share
Explanation by: Vishal Gupta 
Example: SELECT name, age, address FROM employee GROUP BY age;

You must be Logged in to update hint/solution

Discusssion

Login to discuss.

Related MCQs on MySQL

Q. PL/SQL stored procedures move application code from the server to the client.

Q. “NO_DATA_FOUND” and “TOO_MANY_ROWS” are the two most common errors found when executing a SELECT statement.

Q. Which grant table scope columns is case insensitive?

Q. Which of the following is not a feature of MySQL?

Q. The expression 12 DIV 5 evaluates to . . . . . . . .

Q. What does the INSERT INTO Statement do?

Q. Consider a database name "db_name" whose attributes are intern_id (primary key), subject. Intern_id= {1, 2, 3, 4, 5, 6} Subject= {sql, oop, sql, oop, c, c++} If these are one to one relation then what will be the output of the following MySQL statement? SELECT intern_id FROM db_name WHERE subject NOT IN (c, c++);

Q. There is a startup penalty for a standalone interpreter.

Q. Which property determines whether a database object is a case sensitive?

Q. A View can be used to select a subset of the table columns.

Learn All MySQL MCQs