Oracle

Set Operator

Figo Kim 2006. 9. 1. 23:22 
column set_order NOPRINT

select 

 job_id,department_id,3 set_order from employees where department_id = 20

union

select 

 job_id,department_id,1 set_order from employees where department_id = 10

union

select 

 job_id,department_id,2 set_order from employees where department_id = 50

order by set_order