If you don’t specify ASC or DESC after a SQL ORDER BY clause, the following is used by default ______________

Related MCQs

• What is the default order of Order by clause?
• SQL applies predicates in the                 clause after groups have been formed, so aggregate functions may be used.
• 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?
• ANSI-standard SQL allows the use of special operators in conjunction with the WHERE clause. A special operator used to check whether an attribute value is null is
• The UNION SQL clause can be used with _____________
• ‘AS’ clause is used in SQL for
• Which SQL function is used to count the number of rows in a SQL query?
• The              clause allows us to select only those rows in the result relation of the           clause that satisfy a specified predicate.
• Which of the following information does an SQL DDL not specify?