Loading

sorting with multiple parameters

Ani

6y928

I have a employee table as below

EmpID Name JoiningDate Location EntryDate

1 abc 20-05-20 Delhi 25-05-20 10:30:22

2 def 20-05-20 Mumbai 25-05-20 09:45:56

3 ghi 25-05-20 Chennai 25-05-20 13:59:01

4 xyz 20-05-20 Delhi 25-05-20 11:18:48

5 mno 21-05-20 Kolkata 25-05-20 12:05:19

I want retrieve empid by sorting EntryDate desc and ater that sorting JoiningDate asc. Please let me know how to do it.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Guest User6y ago
Accepted answer
SELECT EmpID FROM Employee ORDER BY EntryDate DESC, JoiningDate
Jignesh Kumar6y ago
You can use below query and change order by as per your requrement,
select EmpID Name JoiningDate Location EntryDate from employee
order by Name desc, JoiningDate asc