|
sql
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Group by weekends
Sample data and expected results, please?
Show quoteHide quote "FJC" <F**@discussions.microsoft.com> wrote in message news:936003D9-CC30-4880-AA51-48463A2C6036@microsoft.com... > Hi, > Does anyone know how to group by weekends? Confused,
Do you want to summarise data whcih are falling on week ends ? This is the data:
value year month day 34 2006 2 1 35 2006 2 2 50 2006 2 3 57 2006 2 4 63 2006 2 5 46 2006 2 6 44 2006 2 7 35 2006 2 8 48 2006 2 9 39 2006 2 10 52 2006 2 11 58 2006 2 12 41 2006 2 13 43 2006 2 14 44 2006 2 15 37 2006 2 16 38 2006 2 17 57 2006 2 18 52 2006 2 19 54 2006 2 20 45 2006 2 21 36 2006 2 22 41 2006 2 23 56 2006 2 24 49 2006 2 25 57 2006 2 26 45 2006 2 27 39 2006 2 28 I want the average of the value column but just per each weekend. Show quoteHide quote "dineshasa***@gmail.com" wrote: > Confused, > Do you want to summarise data whcih are falling on week ends ? > > What do you mean?
This answer says nothing. Show quoteHide quote "Doug" wrote: > is this homework? > > hint. datediff(), mod() > > Hi FJC,
Use a calendar table then you will be able to query the joined tables for weekends only. Cheers David Birkedale Show quoteHide quote "FJC" <F**@discussions.microsoft.com> wrote in message news:936003D9-CC30-4880-AA51-48463A2C6036@microsoft.com... > Hi, > Does anyone know how to group by weekends? Thanks David, it worked!
Show quoteHide quote "David Birkedale" wrote: > Hi FJC, > > > Use a calendar table then you will be able to query the joined tables for > weekends only. > > Cheers > David Birkedale > > > > "FJC" <F**@discussions.microsoft.com> wrote in message > news:936003D9-CC30-4880-AA51-48463A2C6036@microsoft.com... > > Hi, > > Does anyone know how to group by weekends? > > >  |
|||||||||||||||||||||||
Other interesting topics