Loading

select statement while loop

Janardhan Reddy

12y1.4kSQL

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.

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Janardhan Reddy12y ago
HI, Thanks for your quick respond . i want to do same result using while loop.pls help on this.
Munesh Sharma12y ago
SELECT CounterNo, SUM(Value), date FROM tablename GROUP BY CounterNo
Pradeep Shet12y ago
Hi, Use below query SELECT CounterNo, SUM(Value), date FROM tbl GROUP BY CounterNo, date ... Considering that date remains same for same counterno
Ramesh Maruthi12y ago
Select counterno, sum(value) as value, date from table
group by counterno