Ani

Ani

  • 169
  • 11.2k
  • 34.9k

sorting with multiple parameters

May 27 2020 10:07 AM
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.

Answers (2)