Gossamer Forum
Home : General : Databases and SQL :

Display first 5 records

Quote Reply
Display first 5 records
Hi
Does someone know how I get Access to give me only the best 5 out of 8 golf scores in a query?
Quote Reply
Re: [jacq] Display first 5 records In reply to
SELECT TOP 5 ID
FROM TABLE
WHERE (SOMECOLUMN = SOMECONDITION)
ORDER BY SCORE DESC
========================================
Buh Bye!

Cheers,
Me