Select the top 3 Scorers From Database Tables 1

[vvicin01]

I have created a table that list the stats of a hockey team. I wish to display
the top three scores (column name 'goals' table 'scrimmage'). I want to return
the top three scores in the the goals column. Can you help.


Thanks
Vic

 

[nickjar2]

Vic,

try this:

SELECT TOP 3 scrimmage.goals
FROM scrimmage
ORDER BY scrimmage.goals DESC;

Nick

 

[vvicin01]

Thanks Nick - That works GREAT!!!

Vic