arvind nitin

arvind nitin

  • NA
  • 18
  • 12.6k

sum of row value date wise

Aug 12 2013 3:58 AM
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.........

Answers (4)