How should I write query for this?

Vote count:

0

I have a table with the columns Employee_Id, Effective_Date, Salary. ie for each employee, I have multiple records based on when their salary got changed. Now I want to print for each employee the salary with the latest effective_date. How to do this?

asked 1 min ago

user2316569

136