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.