help with sql-server query - dates
- by Gold
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