
July 14th, 2004, 01:19 AM
|
|
Registered User
|
|
Join Date: Mar 2004
Posts: 21
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
Trying to select top 5 records
I am currently trying to write a query that will select people who have donated money to our organisation. I only need to find the top 5 donors though.
I know that there is a keyword "TOP" to select this number of records but I can't manage to find anywhere that says where the word is to go in relation to the rest of the SQL statement.
Can anyone help? The syntax at the moment would look something like this:
SELECT Name, Address, Amount FROM Donors WHERE (Amount > 0) ORDER BY Amount;
|