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 |