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 |
|
ASP_DRUG_DEALER
Yak Posting Veteran
61 Posts |
 Posted - 2005-12-08 : 15:51:48
|
| Hey all-I need to select the latest revision from a table and am having no luck.doc_id, rev_number123, 1123, 2123, 4456, 1456, 2I need to be able to get document (123,4) and (456,2).Thanks,Doug |
|
|
SreenivasBora
Posting Yak Master
164 Posts |
Posted - 2005-12-08 : 15:56:03
|
| select doc_id,max(rev_number) from Testgroup by doc_idWith RegardsBSR |
 |
|
|
|
|
|
select the latest revision - over my head!