Archives of the TeradataForum

Message Posted: Tue, 19 Dec 2006 @ 23:20:37 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

How about this:

     select *
        from sys_calendar.calendar
        where day_of_week = 6
        Qualify calendar_date = max(calendar_date)
           over (partition by year_of_calendar)
     ;

Michael Chong

	<Prev	Next>		<<First	<Prev	Next>	Last>>