INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Member Login

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips now!

Talk With Other Members
Be Notified Of Responses
To Your Posts
Keyword Search
One-Click Access To Your
Favorite Forums
Automated Signatures
On Your Posts
Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

LINK TO THIS FORUM!

Tek-Tips LinkedIn^® Group

Join our
LinkedIn^® Group!

Hook up with past and present colleagues and classmates quickly.

Partner With Us!

"Best Of Breed" Forums Add Stickiness To Your Site

(Download This Button Today!)

Feedback

"...Just a quick note to say, "THANKS!" for these forums...The site is very well layed out and easy to use. Thanks for bringing us together - we need each other."

More...

Geography

Where in the world do Tek-Tips members come from?

Click Here To Find Out!

Tek-Tips Shirts!

Get your
Tek-Tips Forums
SWAG here!

Home > Forums > Programmers > DBMS Packages > Microsoft: Access Queries and JET SQL Forum

Top Ten names with best scores

Read More Threads Like This One

georgesOne (TechnicalUser)

17 Apr 12 11:46

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

georgesOne (TechnicalUser)

17 Apr 12 12:00

Just realized that thread701-1680021: Most Recent Record had the same problem solved...
Done.
Thanks, georges

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Back To Forum

Back To Microsoft: Access Queries and JET SQL