help with sql-server query - dates
Posted
by Gold
on Stack Overflow
See other posts from Stack Overflow
or by Gold
Published on 2010-03-21T12:41:29Z
Indexed on
2010/03/21
12:51 UTC
Read the original article
Hit count: 158
sql-server-2008
|query
hi
i have this table:
id|date
1 | 10/11/2009
2 | 13/11/2009
1 | 20/12/2009
3 | 21/12/2009
1 | 30/12/2009
if i stand on the last record (id=1) and i need to see the last date where
id=1 is appear --> will show me: 1 | 20/12/2009
what query will do it ?
thank's in advance
© Stack Overflow or respective owner