Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Top Ten names with best scores

Status
Not open for further replies.
georgesOne

georgesOne

Technical User
Jul 2, 2004
176
0
0
JP
I have a table with names and test scores for several years:

Name Year Score
AAA 2005 750
AAA 2010 730
BBB 2009 320
CCC 2011 650
....
....
....
I want the top ten (name, year, score), but AAA who would be among the top ten twice - because scores 730 and 750 would be among the top ten - should be mentioned only once.
How to do with SQL? Thanks for any help.
georges
 
Sort by date Sort by votes
Just realized that thread701-1680021 had the same problem solved...
Done.
Thanks, georges
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

datajockey123
  • Question
Note / Information box with date and time stamp for each entery
Replies
2
Views
230
dhookom
dhookom
serino
  • Locked
  • Question
Delete with WHERE Clause. 2
Replies
4
Views
218
serino
serino
serino
  • Locked
  • Question
Help with SQL inner join statement 1
Replies
2
Views
120
serino
serino
TrekBiker
  • Locked
  • Question
Ranking with allowance for tied scores 1
Replies
3
Views
52
TrekBiker
TrekBiker
teamssc
  • Locked
  • Question
Trouble with Parameter Query 1
Replies
4
Views
118
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top