COMPUTER SCIENCE AND ENGINEERING
SQL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
SELECT, FROM, ORDER BY, WHERE
|
|
|
SELECT, FROM, WHERE, ORDER BY
|
|
|
SELECT, WHERE, FROM, ORDER BY
|
|
|
WHERE, FROM, SELECT, ORDER BY
|
Detailed explanation-1: -The correct answer is Select, where, group by, having.
Detailed explanation-2: -In fact, the logical order is this: The FROM clause: First, all data sources are defined and joined. The WHERE clause: Then, data is filtered as early as possible. The CONNECT BY clause: Then, data is traversed iteratively or recursively, to produce new tuples.
Detailed explanation-3: -ORDER BY Characteristics: The ORDER BY clause is used to get the sorted records on one or more columns in ascending or descending order. The ORDER BY clause must come after the WHERE, GROUP BY, and HAVING clause if present in the query. Use ASC or DESC to specify the sorting order after the column name.
Detailed explanation-4: -You can use the WHERE clause with or without the ORDER BY statement.