select statement while loop

Question

 Hi

Iam new for Sql I want fetch the data from DB below format using while loop .pls help me

 This is my DB data look like :

counterno	value	date
1	200	6-Oct-14
1	300	6-Oct-14
2	100	6-Oct-14
2	800	6-Oct-14
3	900	6-Oct-14
4	100000	6-Oct-14
5	2000	6-Oct-14
5	3000	6-Oct-14
7	200	6-Oct-14
7	100	6-Oct-14

 

I want out put like this.

 

counterno	value	date
1	500	6-Oct-14
2	900	6-Oct-14
3	900	6-Oct-14
4	100000	6-Oct-14
5	5000	6-Oct-14
7	300	6-Oct-14