Now You Try It
Sort your last request in descending order by employee last name and employee first name.
The result looks like this:
EMP_ID EMP_LNAME EMP_FNAME SKILL_ID ------ --------- --------- -------- 2174 Zander Jonathan 4430 3118 Wooding Alan 5180 5090 Wills Stephen 7000 3411 Williams Catherine 5500 3991 Wilkins Fred 7000 2424 Wilder Ronald 6470 2106 Widman Susan 6770 4962 White Peter 5130 3338 White Mark 6770 3222 Voltmer Louise 1000 3222 Voltmer Louise 4430 2781 Thurston Joseph 5420 2781 Thurston Joseph 5430 4456 Thompson Thomas 3065 4456 Thompson Thomas 6670 4001 Thompson Jason 7000 2437 Thompson Henry 3333 2437 Thompson Henry 4444 3449 Taylor Cynthia 5200 2209 Smith Michael 5309 3341 Smith Carl 5309 3288 Sampson Ralph 6670 3288 Sampson Ralph 6650 3288 Sampson Ralph 3333 4002 Roy Linda 4410 4002 Roy Linda 4370 4358 Robinson Judith 5500 2010 Parker Cora 7000 3764 Park Deborah 7000 3704 Moore Richard 7000 1234 Mills Thomas 1000 4660 MacGregor Bruce 7000 2448 Lynn David 7000 3767 Lowe Frank 7000 2004 Johnson Eleanor 6770 3294 Johnson Carolyn 6770 2598 Jacobs Mary 6666 2246 Hamel Marylou 1000 2246 Hamel Marylou 6670 4703 Halloran Martin 5130 4703 Halloran Martin 4250 2894 Griffin William 5500 2894 Griffin William 1000 1034 Gallway James 6470 5008 Fordman Timothy 6770 3778 Ferndale Jane 6666 3778 Ferndale Jane 5200 5103 Ferguson Adele 5200 3769 Donelson Julie 5309 4773 Dexter Janice 5309 3841 Cromwell Michelle 4370 . . . 69 rows processed
If your results do not match what you see above, check Review Answers for Chapter 6 for the correct SQL syntax. Remember that result tables may be shortened in this guide.
|
Copyright © 2014 CA.
All rights reserved.
|
|