June 25, 2015

Teradata tableless union example

select '123' as emp_no from (select '0' as dummy) as x
union
select '456' as emp_no from (select '0' as dummy) as x