Hi,

SELECT Employeeid,max(Amount),receiveddate from table

group by Employeeid,receiveddate.:-)

Varun R

http://www.sqlinfo.in