× Didn't find what you were looking for? Ask a question
Top Posters
Since Sunday
s
3
v
3
p
3
m
2
s
2
d
2
N
2
d
2
e
2
s
2
s
2
e
2
Home Q & A Board Other Fields Homework Help Business Management
New Topic  
Kao Kao
wrote...
Go to Answer
Posts: 634
Rep: 0 0
6 years ago
The SQL query to output the contents of the EMPLOYEE table sorted by last name, first name, and initial is _____.
 a. SELECT EMP_LNAME, EMP_FNAME, EMP_INITIAL, EMP_AREACODE, EMP_PHONEFROM EMPLOYEELIST BY EMP_LNAME, EMP_FNAME, EMP_INITIAL;
 b. SELECT EMP_LNAME, EMP_FNAME, EMP_INITIAL, EMP_AREACODE, EMP_PHONEFROM EMPLOYEEORDER BY EMP_LNAME, EMP_FNAME, EMP_INITIAL;
 c. SELECT EMP_LNAME, EMP_FNAME, EMP_INITIAL, EMP_AREACODE, EMP_PHONEFROM EMPLOYEEDISPLAY BY EMP_LNAME, EMP_FNAME, EMP_INITIAL;
 d. SELECT EMP_LNAME, EMP_FNAME, EMP_INITIAL, EMP_AREACODE, EMP_PHONEFROM EMPLOYEESEQUENCE BY EMP_LNAME, EMP_FNAME, EMP_INITIAL;
Read 37 times
1 Reply
Replies
Answer verified by a subject expert
unique101unique101
wrote...
#1
Top Poster
Posts: 917
Rep: 5 0
6 years ago
Sign in or Sign up in seconds to unlock everything for free
1

Related Topics

Kao Author
wrote...

6 years ago
Thanks
africa143
wrote...

Yesterday
Thanks for your help!!
Smair87
wrote...

2 hours ago
Just got PERFECT on my quiz
New Topic      
Quick Reply
Explore
Post your homework questions and get free online help from our incredible volunteers
  910 People Browsing
 160 Signed Up Today
Start New Topic Take the Tour CoursesNew Study Tools Topics Trending Browse by Textbook
Live Chat
Related Images
  
 277
  
 265
  
 388
Your Opinion
Who will win the 2024 president election?
Votes: 119
Closes: November 4
Previous poll results: Which industry do you think artificial intelligence (AI) will impact the most?