Ascending Order and Descending Order Query

How to write a query to list the items in ascending order of Name and within Name, in descending order of Salary

Showing Answers 1 - 9 of 9 Answers

Neha

  • Jan 7th, 2016
 

Select * from Employee order by Name,Salary desc

  Was this answer useful?  Yes

vaibhav

  • Jan 11th, 2016
 

Code
  1. SELECT lastname,salary FROM employee ORDER BY lastname,salary;

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions