Home Forums SQL Server 2008 SQL Server 2008 - General how to find max amount RE: how to find max amount
Subbu S
Old Hand
Points: 359
More actions
August 25, 2010 at 11:37 pm
#1212073
SELECT EMPNAME,
AMOUNT,
RECIVEDDATE
FROM Table_Name A
WHERE RECIVEDDATE = (SELECT MAX(Reciveddate) FROM Table_Name B WHERE A.RecivedDate = B.RecivedDate)
Plz let me knw, whther this query solved your problem