Hi! I have Salary Table and I want to retrive data on Max date. following is table
| ID | EMP ID | FROM DATE | BASIC | 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 DATE | BASIC | DA |
| 2 | LPPL077 | 01-01-2019 | 4000 | 1000 |
| 3 | LPPL078 | 01-01-2020 | 6000 | 1200 |
what shold query to retrive above output? pls help....