I have the following problem.
A table with different dates and salary for the employee
LIKE:
date emp. salary
010197 100 123,4
010197 101 111,3
010197 102 109,4
010197 103 105,5
010297 100 149,4
010297 101 143,2
010297 103 122
010297 102 111

the table is sorted by date and salary dec.

if I now want the AVG() of the 3 best
salaries sorted by date, how do I accomplish
that!!! I'm stuck!!

I wonder if a SELECT can solve my problem??

Best regards

Per Simmersholm