SQL to Retrieve 5 Records

[simsjr]

Anyone know a simple SQL statement to retrieve any 5 records from a query?
Doesn't matter which 5 either.

 

[Graham Mandeno]

Use the TOP predicate:

SELECT TOP 5 .... FROM ....

 

[simsjr]

Right on!

Now just for kicks, is there any way to randomize the 5 records I get back?

Use the TOP predicate:

SELECT TOP 5 .... FROM ....
--
Good Luck!

Graham Mandeno [Access MVP]
Auckland, New Zealand

Anyone know a simple SQL statement to retrieve any 5 records from a query?
Doesn't matter which 5 either.

 

[John Vinson]

Right on!

Now just for kicks, is there any way to randomize the 5 records I get back?

SELECT TOP 5 ...
FROM tablename
ORDER BY Rnd([ID])

where ID is some non-negative numeric field in your table.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps