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 :

I want out put like this.

Janardhan Reddy · Answer

HI Thanks for your quick respond . i want to do same result using while loop.pls help on this.

Munesh Sharma · Answer

SELECT CounterNo SUM(Value) date FROM tablename GROUP BY CounterNo

Pradeep Shet · Answer

Hi Use below query SELECT CounterNo SUM(Value) date FROM tbl GROUP BY CounterNo date ... Considering that date remains same for same counterno

Ramesh Maruthi · Answer

Select counterno sum(value) as value date from table group by counterno