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

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

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

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

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

Answers

select statement while loop

Janardhan Reddy

11y

816

1 Server Controls

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.

Forum Statistics

Upcoming Events

View all