Select Max Date with More than One Result
583143Mar 23 2009 — edited Mar 23 2009Hello;
I need to write a query that returns the max date for a specific transaction which is no problem at all, but my problem occurs, when i have multiple transactions that have the same max trans date.
Can someone help me write something that will return only one record from a result set that has more than one record
Example:
TRAN_ID --- ACT# --- TRANS_DATE
- 272 - 1111111 - 10/29/1999 00:00:00
- 273 - 1111111 - 10/29/1999 00:00:00
- 274 - 1111111 - 10/29/1999 00:00:00
- 275 - 1111111 - 10/29/1999 00:00:00