COMPUTER SCIENCE AND ENGINEERING
SQL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
SORT BY
|
|
|
ALIGN BY
|
|
|
ORDER BY
|
|
|
GROUP BY
|
Detailed explanation-1: -The ORDER BY keyword is used to sort the result-set in ascending or descending order. The ORDER BY keyword sorts the records in ascending order by default. To sort the records in descending order, use the DESC keyword.
Detailed explanation-2: -SQL uses the ORDER BY statement to sort records. You can sort records in ascending or descending order, and you can sort records based on multiple columns.
Detailed explanation-3: -Under Table Tools, on the Layout tab, do one of the following: To add a row above the cell, click Insert Above in the Rows and Columns group. To add a row below the cell, click Insert Below in the Rows and Columns group.
Detailed explanation-4: -In SQL, a view is a virtual table based on the result-set of an SQL statement. A view contains rows and columns, just like a real table.
Detailed explanation-5: -To define what columns should be displayed in an SQL SELECT statement: use FROM to name the source table(s) and list the columns to be shown after SELECT.