Retrieving the Primary Key when Retreiving Top Values of Groups.

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.

All Forums

SQL Server 2000 Forums

Transact-SQL (2000)

Retrieving the Primary Key when Retreiving Top Values of Groups.

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-08-29 : 18:50:59

Tony writes "How do you identify the primary key for the top value for each racer's best time?


UniqueID    Name         Time
--------    ----         ----
1           John          1.40
2           John          1.35
3           John          1.20
4           Sally         1.85
5           Sally         1.10
6           Sally         1.30
7           Henry         2.50
8           Henry         2.10
9           Henry         2.65

Thanks,

Tony"

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources