Hi Everyone,
I have a table with the following structure
EmployeeID Number
Year1 Date
Salary1 Number
Year2 Date
Salary2 Number
Year3 Date
Salary3 Number
Year4 Date
Salary4 Number
Year5 Date
Salary5 Number
This table stores the top five salaries of the employee, ordered by year, so year1 always be the most recent year of the top five. Now, my problem is I need the top four out of this list ordered by salary, not year. Any hints or pointers?
Thanks,
Lauren McDonald, B.Sc.
Programmer Analyst
Saskatchewan Healthcare Employees' Pension Plan
I have a table with the following structure
EmployeeID Number
Year1 Date
Salary1 Number
Year2 Date
Salary2 Number
Year3 Date
Salary3 Number
Year4 Date
Salary4 Number
Year5 Date
Salary5 Number
This table stores the top five salaries of the employee, ordered by year, so year1 always be the most recent year of the top five. Now, my problem is I need the top four out of this list ordered by salary, not year. Any hints or pointers?
Thanks,
Lauren McDonald, B.Sc.
Programmer Analyst
Saskatchewan Healthcare Employees' Pension Plan