Select top 5 from query

[AlanW]

I have the following query. I'd like to show/select only the top 5 records. Can anyone advise me on how to do this?

SELECT DISTINCTROW PYVOAP.[AP Code], PYVOAP.[AREA OF PRACTICE], PYVOAP.[File Number], PYVOAP.[Client Surname], Sum(PYVOAP.Costs) AS [Sum Of Costs]
FROM PYVOAP
GROUP BY PYVOAP.[AP Code], PYVOAP.[AREA OF PRACTICE], PYVOAP.[File Number], PYVOAP.[Client Surname]
ORDER BY PYVOAP.[AP Code];

 

[Galaxiom]

select top 5 distinctrow .....

WTF? I copied the code in capitals but the post automatically turned it to sentence case.

So I put it in a code box and it turned it all to lower case.

 

[AlanW]

Thanks GalaxiomAtHome . . Unfortunately that doesn't work . . I get syntax errors when I try that. . I wish it were that simple

 

[Galaxiom]

It should work using a subquery.

SELECT TOP 5 fieldname1, fieldname2 etc
FROM (SELECT etc

 

[jsteeleiii@cox.net]

The top 5 would need to go after the SELECT DISTINCTROW:
SELECT DISTINCTROW TOP 5