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-07-03 : 08:50:09
|
| Matt writes "I am stuck on a problem that I am hoping you could advise.I have a table with the following fields:Participant_idstatus rank dateNew rows are constantly inserted into the table updating the Participant's new status and rank. I need to write a query that will allow me to bring back a recordset that has current status, former status and highest rank. The values for status and rank are numeric (1-5). I am guessing I would use the max date but that is as far as I could get. Any help would be appreciated.Thanks,Matt" |
|
|
|
|
|
SQL Statement