>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??
>
You could do a Select Top 3 and then Average that.