[thelist] get avg of last 3 records in SQL

Michael Robertson mike at mikeemedia.com
Thu Nov 7 10:49:00 CST 2002


--
[ Picked text/plain from multipart/alternative ]
how can i get the average of the last 3 records entered by a particlar user? or even just the last 3 records and do the math elsewhere.

idea along the lines of
select avg(steps) as steps from tblSteps where user='100' and  record=the last 3

thanks
--





More information about the thelist mailing list