sql server - Retrieving n rows per group - Database Administrators Stack Exchange
The typical way to do this in SQL Server 2005 and up is to use a CTE and windowing functions. For top n per group you can simply use ROW_NUMBER() with a PARTITION clause, and filter against that in the outer query. So, for example, the top 5 most recent ....
網址安全性掃描由 
提供
