Top 5 with grouping

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to get the top 5 results for each region. Any help would be
appreciatted, below is my sql thus far.

SELECT TOP 5 QryNullConv.AbsError, QryNullConv.DmdUnit, QryNullConv.Loc,
QryNullConv.Region
FROM QryNullConv;
 
TOP 5 for the region based on what.- the number of AbsError?

SELECT q.Region, q.AbsError, Q.DmdUnit, Q.Loc
FROM qryNullConv as Q
WHERE Q.AbsError in (
SELECT TOP 5 absError
FROM qryNullConv as T
WHERE T.Region = Q.Region
ORDER BY absError DESC)


--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Select Top with aggregate function 1
Selecting top 5 2
Top 5 by a GROUPing? 1
Top 5 grouping of material based on usage 2
Remove Ties from a Top 5 query 10
Select Top 5 10
Top Values within multiple groups 6
Grouping Top Values 1

Back
Top