Return all leap years

 Return all leap years:

The SQL for this is straightforward:

select day_date_year

from dateset

where day_date_month = 2

and day_date_day = 29

group by day_date_year

,day_date_month

 

 

 

 

source: Business Objects Advance Query building guide.

 

Leave a Reply