AVG TOP 5 Query

A

AJ

Can you do a select and get the avgerage of the top 5 values?

example - select top 5 AVG(sales) from table_1?

This seems to still do an average of ALL the rows.

Thanks a ton.
AJ
 
A

Arvin Meyer [MVP]

AJ said:
Can you do a select and get the avgerage of the top 5 values?

example - select top 5 AVG(sales) from table_1?

This seems to still do an average of ALL the rows.

Thanks a ton.
AJ
Click to expand...

Write a queryto return the Top 5 values. Use that query as the source for
the aggregate query to get the average.
 
Top