4.13 Sorting Query
This example illustrates the use of the “order by” clause
to sort a table on multiple columns.
SQL Statement
SELECT NDS_Context, Surname
FROM UserNDS
ORDER BY NDS_Context, Surname
Result Table
Table 4-11 Sorting Query Result Report
|
Marketing.Fred’s Widgets |
Bergman |
|
Marketing.Fred’s Widgets |
Fairbanks |
|
Marketing.Fred’s Widgets |
Gilbert |
|
Marketing.Fred’s Widgets |
Metcalf |
|
Operations.Fred’s Widgets |
Metcalf |
|
Operations.Fred’s Widgets |
Garcia |
|
Operations.Fred’s Widgets |
Garcia |
|
Operations.Fred’s Widgets |
Madsen |
|
Product Development.Fred’s Widgets |
Hancock |
|
Product Development.Fred’s Widgets |
Sanders |
|
Product Development.Fred’s Widgets |
Smith |
|
Product Development.Fred’s Widgets |
Weirsdorf |
|
Sales.Fred’s Widgets |
Anderson |
|
Sales.Fred’s Widgets |
Desmond |
|
Sales.Fred’s Widgets |
Knight |
|
Sales.Fred’s Widgets |
Purdy |
|
Sales.Fred’s Widgets |
Turnet |