Informatics Practices
Assertion. The ORDER BY clause of SELECT statement is carried out in the last after executing other clauses of the SELECT statement.
Reason. The ORDER BY clause is carried out on the final result of the SELECT query.
- Both A and R are true and R is the correct explanation of A.
- Both A and R are true but R is not the correct explanation of A.
- A is true but R is false.
- A is false but R is true.
Answer
Both A and R are true and R is the correct explanation of A.
Explanation
In SQL, the execution order of a SELECT statement is such that the ORDER BY clause is processed last, after all other clauses like FROM, WHERE, GROUP BY, HAVING, and SELECT have been executed. This is because the ORDER BY clause sorts the final result set produced by these earlier steps.
Related Questions
ORDER BY can be combined with the SELECT statements.
The SQL keyword GROUP BY instructs the DBMS to group together those rows that have the same value in a column.
Assertion. MOD() and MIN() are numeric functions, yet they are different types of functions.
Reason. MOD() is a single-row function and MIN() is a group function.
- Both A and R are true and R is the correct explanation of A.
- Both A and R are true but R is not the correct explanation of A.
- A is true but R is false.
- A is false but R is true.
Assertion. The GROUP BY clause can use any type of function.
Reason. The GROUP BY clause combines a number of rows in a group and applies functions on it.
- Both A and R are true and R is the correct explanation of A.
- Both A and R are true but R is not the correct explanation of A.
- A is true but R is false.
- A is false but R is true.