How many Fridays are in each month

How many Fridays are in each month?

 To answer this query you use grouping and counting:

 select day_date_yearmonth

 day_date_month,

 count (1)

 from dateset

 where day_date_dayofweek = 5

 group by day_date_year,

 day_date_month

 

source: Business Objects Advance Query building guide.

Leave a Reply