Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
will0122
Starting Member
11 Posts |
 Posted - 2010-03-04 : 18:31:02
|
| Hi to all,I have the following SQL code. Basically what it does it gives me the Average of the last 5 scores of each member of a database that contains several members and more that 5 scores per member. This works very well with SQL but I want to be able to do this in MS Access. Any suggestion?Thanks in advanced.i have tSELECT a.rcaf, avg(a.score * 1.0) AS [Average] FROM (SELECT rcaf, score, [ReviewdON], Row_number() OVER(PARTITION BY rcaf ORDER BY [ReviewdON] DESC) AS seq FROM VerintInfo) a WHERE a.seq <= 3 GROUP BY a.rcaf |
|
|
|
|
|
Partition in Access