i have records like the one below Name Amount Balance Edd 500 500 Tee 200 200 Edd 700 1200 Tee 400 600 How can i query to get the last rows of each name like Name Amount Balance Edd 700 1200 Tee 400 600 Thanks