Getting an Average from a TOP N Query?

[mtl77]

Does someone know how to get an average from a TOP n query like the following?


SELECT TOP 10 myColoum FROM myTable Where tableID = aValue Order by myColoum.

Any help would be greatly appreciated.

 

[ClaireHCM]

Try~~

select avg(mycoloum) as average from (SELECT TOP 10 myColoum FROM myTable Where tableID = aValue Order by myColoum) B

 

[mtl77]

Great that works perfectly, Thanks for the help ClaireHsu!