Gossamer Forum
(Advanced Search)
for
Home : General : Databases and SQL :

Display first 5 records

Mar 7, 2004, 2:18 AM
jacq
New User (3 posts)
Mar 7, 2004, 2:18 AM
Post #1 of 2
Views: 4845
Shortcut
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?
Mar 7, 2004, 9:53 PM
Stealth
Veteran (17240 posts)
Stealth's avatar
Mar 7, 2004, 9:53 PM
Post #2 of 2
Views: 4581
Shortcut
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