Raju Fodse

Raju Fodse

  • 1.5k
  • 244
  • 31.5k

Retrieve data on MAX Date

Jan 8 2021 9:13 AM
Hi! I have Salary Table and I want to retrive data on Max date. following is table
 ID EMP ID FROM DATEBASIC  DA
 1 LPPL078 01-01-2019 5000 1000
 2 LPPL077 01-01-2019 4000 1000
 3 LPPL078 01-01-2020 6000 1200
  
and output should be as fallow
ID EMP ID MAX DATEBASIC  DA
 2 LPPL077 01-01-2019 4000 1000
 3 LPPL078 01-01-2020 6000 1200
 
what shold query to retrive above output? pls help.... 

Answers (2)