V

Vishal Gupta • 7.73K Points
Tutor III 

Q. Which clause is used to sort the result by one or more columns?

  • (A) HAVING
  • (B) FROM
  • (C) ORDER BY
  • (D) WHERE
  • Correct Answer - Option(C)
  • Views: 121
  • Filed under category MySQL
Explanation by: Vishal Gupta 
Example: 
SELECT name, age, address FROM employee ORDER BY name;

You must be Logged in to update hint/solution

Discusssion

Login to discuss.

Be the first to start discuss.

Related MCQs on MySQL

Q. The keyword used with UNION that retains duplicate rows is . . . . . . . .

Q. The facility that allows nesting one select statement into another is

Q. What is xyz in the following MySQL statement? CREATE VIEW xyz AS SELECT a, b FROM t;

Q. Which of these take more space? Variable length columns, Fixed length columns

Q. The default case sensitivity of database and table names depends on

Q. The join in which all the rows from the right table appear in the output irrespective of the content of the other table is

Q. Which data type character merges the "Check Constraint" into a data type definition?

Q. Which clause is used to filter groups?

Q. Can we create a database named 01_test?

Q. What will be the output of the following MySQL command? SELECT * FROM person WHERE emp_id IS NULL;

Learn All MySQL MCQs

Question analytics