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 |
|
swims01
Yak Posting Veteran
59 Posts |
 Posted - 2009-05-01 : 16:45:37
|
| Hey guys.I'd like to select the highest record id for each individual person with criteria.ex.Select * from tbl where criteriabut it has to take into account the person's highest record.ex data.record, name, date1, don, 1/1/20092, don, 1/1/20093, jack, 2/1/20094, don, 4/1/20095, jack, 4/5/2009the select statement would return...4, don, 4/1/20095, jack, 4/5/2009 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
swims01
Yak Posting Veteran
59 Posts |
Posted - 2009-05-04 : 15:48:55
|
| Tara -Does that return results based on the max date or max record?Edit* From that I was able to figure out the rest. Thanks, yet again, Tara =) |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
|
|
Select the highest record for a person w/ criteria