Now You Try It
Change the example above so that it is sorted in descending order. Specify DESC after the column name in the ORDER BY clause.
The result looks like this:
EMP_ID EMP_LNAME ------ --------- 2174 Zander 3118 Wooding 5090 Wills 3411 Williams 3991 Wilkins 2424 Wilder 2106 Widman 3338 White 4962 White 3222 Voltmer 2898 Umidy 2781 Thurston 2437 Thompson 4456 Thompson 4001 Thompson 3449 Taylor 2299 Spade 2209 Smith 3341 Smith 3288 Sampson 4002 Roy 4358 Robinson 2010 Parker 3764 Park 3704 Moore 1234 Mills 4660 MacGregor 2448 Lynn 3767 Lowe 3199 Loren 2004 Johnson 3294 Johnson 2598 Jacobs 2246 Hamel 4703 Halloran 2894 Griffin 1034 Gallway 5008 Fordman 3778 Ferndale 5103 Ferguson 3769 Donelson 4773 Dexter 3841 Cromwell 3433 Crane 4027 Courtney 4008 Clark 2145 Catlin 2096 Carlson 3082 Brooks 4321 Bradley 2466 Bennett 1003 Baldwin 2461 Anderson 1765 Alexander 2180 Albertini 55 rows processed
If your results do not match what you see above, check Exercise 3-7 Answer in Review Answers for Chapter 3 for the correct SQL syntax. Remember that result tables may be shortened in this guide.
|
Copyright © 2014 CA.
All rights reserved.
|
|