常用SQL语句

1.如何把多个select查询结果拼接成一张表

select * from ((select 1 aa from dual) a,(select 1 bb from dual) b,(select 1 cc from dual) c)

2.