I have following tables
tbl1 (empID, Name, ctNo)tbl2 (salID, empID, salry)tbl3 (histryID, salDate, empID, salID)
Expect Output (empID,Name,salary,Salary_Date)
For all employees. dont want to display employees all the salary date. Display last salaryDate.
By using Partitiion by or Selfjoin methods.
Thank You
Get back soon Friends.