Choose Category
WITH CTE_name(column list) AS ( SELECT column list FROM table [(WHERE condition)] ) SELECT * FROM CTE_name;
WITH cte_emp(city) AS ( SELECT city FROM tbl_emp WHERE Emp_id=03 UNION ALL SELECT city FROM tbl_emp WHERE Emp_id=12 ) SELECT * FROM cte_emp;