Loading

sum of row value date wise

arvind nitin

13y1.6k

create table Table1
(
TB1_ID varchar(100),
TB1_DT varchar(100),
TB1_PRC varchar(100),
TB1_US varchar(100)
)
 
select * from Table1

and

my table is:

TB1_ID  TB1_DT        TB1_PRC   TB1_US
 
1	2/8/2013	100	60
2	5/8/2013	1000	600
3	7/8/2013	11000	6100
4	8/8/2013	12000	6200
5	9/8/2013	13000	6300

i want to get average(for many values) of TB1_PRC from TB1_DT 5/8/2013 to 10/8/2013.
but how.........

4 Replies

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

Iftikar Hussain13y ago
Accepted answer
Hi,
Try like this

select AVG(TB1_PRC) as Result from Table1 where TB1_DT>='5/8/2013' and TB1_DT<='10/8/2013'

Regards,
Iftikar
arvind nitin13y ago
thanx sir, it's working
Iftikar Hussain13y ago
select AVG(TB1_PRC) as Result from Table1 where TB1_DT>='5/8/2013' and TB1_DT<'10/8/2013'

Regards,
Iftikar
arvind nitin13y ago
my friend Iftikar,
i want to get average between 5/8/2013 from 10/8/2013(means 9/8/2013)