I can't remember or find the script to pull the highest 4 out of a column. I then need the average but that I got.
Any help would be greatly appreciated!
Select Avg(Data) As TheAverage
From (
Select Top 4 YourColumnName As Data
From YourTableName
Order BY YourColumnName
) As Top4Data
-George
Microsoft SQL Server MVP My Blogs SQLCop twitter
"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.