General information
Category:
Coding, syntax & commands
>>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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only