>>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.


Bruce

What is a "Select Top 3" ???

Per