Advanced Averaging.....

[fenneraj]

Hi,
I would like to be able to calculate averages for the last 50 records in my database only.

Using the statement:
SELECT AVG(qu1Radio) AS qu1AVG..........

This takes an average of all 1100 records. Could it be done by providing arguments directly to the AVG clause or by using WHERE statements, if so how can this be done.

I thank you all for your help in advance.

Regards
Andrew Fenner

 

[bdreed35]

You can use a SUBQUERY in the WHERE clause to accomplish this:

SELECT AVG(qu1Radio) AS qu1AVG
FROM table
WHERE UpdateDate IN (SELECT TOP 50 UpdateDate FROM table ORDER BY UpdateDate DESC)

~Brian