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: 115
  • 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. Which among the following tags belong to Data Manipulation language?

Q. What will be the output of the following MySQL command? SELECT emp_id, fname, lname FROM employee WHERE title=’HEAD TELLER’;

Q. What is the maximum collations a character set can have?

Q. Transactional processing requires lesser overhead due to CPU cycles and memory.

Q. Which system variable determines the number of rows from INSERT DELAYED statements that can be queued per table?

Q. Which of these is faster when accessing data? memory, disk

Q. The security context when a user creates a stored program that accesses sensitive data but forgets that other people who can invoke the object have the same access is . . . . . . . .

Q. Which of the following can be used interchangeably with MYSQL_VERSION_ID?

Q. Pragmas are processed at ___________

Q. What is used to perform analysis of key values by the server?

Learn All MySQL MCQs

Question analytics