subject:"\[SQL\] Group by on Date"

Re: [SQL] Group by on Date

2011-10-16 Thread Harald Fuchs

In article <1318661510830-4904685.p...@n5.nabble.com>, "maya.more" writes: > I have a table with Date and unit column. . I want to find sum of unit column > considering 3 days each > User will specify start and enddate > Eg > DateUnit > 10/1/2011 1 > 10/2/2011 2 > 10/3/201

Re: [SQL] Group by on Date

2011-10-16 Thread Andreas Kretschmer

maya.more wrote: > I have a table with Date and unit column. . I want to find sum of unit column > considering 3 days each > > User will specify start and enddate > > Eg > > DateUnit > 10/1/2011 1 > 10/2/2011 2 > 10/3/2011 3 > 10/4/2011 4 > 10/5/2011 4 > 10/6/

[SQL] Group by on Date

2011-10-16 Thread maya.more

I have a table with Date and unit column. . I want to find sum of unit column considering 3 days each User will specify start and enddate Eg DateUnit 10/1/2011 1 10/2/2011 2 10/3/2011 3 10/4/2011 4 10/5/2011 4 10/6/2011 1 10/7/2011 2 10/8/2011 3 10/