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