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-01-14 : 23:42:18
|
LaundroMat writes "Hi there,
Suppose I had this table:
ID - EmployeeID - Paid
1 - 1 - 500
2 - 1 - 1500
3 - 2 - 200
4 - 1 - 250
5 - 3 - 1400
6 - 2 - 210
Then how could I query my Access database in order to get the top pays per EmployeeID?
i.e. result =
EmployeeID - Paid
1 : 1500
2 : 210
3 : 1400
Thanks!
PS I'm using Access 97 and ASP. (Dunno about the SQL Server though, sorry.)" |
|
|
|
|
|
Getting top salaries per employee with the same employee figuring more than once in a table