Which SQL keyword is used to sort the result-set?

Related MCQs

• Which of the following function is used to find the column count of the particular resultset?
• Which SQL keyword is used to retrieve a maximum value?
• The SQL keyword(s) ________ is used with wildcards.
• Which SQL function is used to count the number of rows in a SQL query?
•                  dump, writes out SQL DDL statements and SQL insert statements to a file, which can then be reexecuted to re- create the database.
• View the Exhibit and examine the data in the EMPLOYEES tables. Evaluate the following SQL statement: SELECT employee_id, department_id FROM employees WHERE department_id= 50 ORDER BY department_id UNION SELECT employee_id, department_id FROM employees WHERE department_id= 90 UNION SELECT employee_id, department_id FROM employees WHERE department_id= 10; What would be the outcome of the above SQL statement?
• What is the default “SORT” order for a SQL?
• The                  keyword is used to access attributes of preceding tables or subqueries in the from clause.
• Which of the following is used as the embedded SQL in COBOL?
• Which of the following is used to distinguish the variables in SQL from the host language variables?