COMPUTER SCIENCE AND ENGINEERING
SQL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Match the following SQL term with a description-ORDER BY
|
|
The fields to display
|
|
|
The field and order used to sort the results
|
|
|
The table used in the query
|
|
|
The criteria that must be met
|
Explanation:
Detailed explanation-1: -Detailed Solution. The correct answer is Select, where, group by, having.
Detailed explanation-2: -Six Operations to Order: SELECT, FROM, WHERE, GROUP BY, HAVING, and ORDER BY.
Detailed explanation-3: -The DESC command is used to sort the data returned in descending order.
Detailed explanation-4: -SELECT statements The syntax is: SELECT column1, column2 FROM table1, table2 WHERE column2=’value’; In the above SQL statement: The SELECT clause specifies one or more columns to be retrieved; to specify multiple columns, use a comma and a space between column names.
There is 1 question to complete.