I have a table that looks kinda like this
Tag         Info              SignOutDate
1             Hi                   09/03/2005
1             Hi                   09/02/2005
1             Hi                   08/19/2005
2             Hi                   09/03/2005
12           Hi                   09/03/2005
12           Hi                   08/12/2005
18           Hi                   09/03/2005
Now I want to select each TAG # for the latest SignOutDate.  I then have to link it to other tables which I can prolly figure out.  But is this all possible in one statement?
Select Tag
From Table
Where SignOutDate = (Select MAX(SignOutDate) From Table)
Marcie
 
No comments:
Post a Comment