| Refresh | Home EGTry.com


 select PromptYear from (select extract(year from current_date) -2 PromptYear) t3
 union all
 select PromptYear from (select extract(year from current_date) -1 PromptYear) t2
 union all
 select PromptYear from (select extract(year from current_date)     PromptYear) t1


result

PromptYear
2009
2010
2011

Note: Union All does not remove duplicates