[WITH [RECURSIVE] with_query [,…] ] SELECT …

With 
	Subtable1 as (select 1...),
	Subtable2 as (select 2...), 
	Subtablen as (select n...) 
Select …

with tmp as (
select empno ,ename ,sal 
from db_hive.emp)
select t.empno,t.ename,t.sal from tmp t ;