Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-03-14 : 23:56:14
|
JL writes "I can't find the answer to this one anywhere, and yet it seems a fairly straighforward thing to try and do - I could only think of a solution using extra code which surely overcomplicates it....
I have three fields - event, personID and mark. I want a list of the 10 best marks for each personID. However when I use 'TOP 10' within a SELECT query it only returns 10 records in total which isn't what I want.
Please help!" |
|
|
|
|
|
Top 10 marks for each person