I have a table master with attributes:ID,name,amount,date
on 04/05/2010 I entered the the data as (100,'Albert',50000,'04/05/2010')
on 05/05/2010 I entered the the data as (101,'Perera',20000,'05/05/2010')
on 06/05/2010 I entered the the data as (105,'Dixon',50000,'06/05/2010')
on 07/05/2010 I entered the the data as (100,'Albert',80000,'07/05/2010')
on 08/05/2010 I entered the the data as (105,'Dixon',10000,'08/05/2010')
on 09/05/2010 I entered the the data as (100,'Albert',90000,'09/05/2010')
on 10/05/2010 I entered the the data as (100,'Albert',20000,'10/05/2010')
I required the result as below
Id Name Amount
100 Albert 240000
101 Perara 20000
105 Dixon 60000