方法1:(不报错,达不到效果)
select count(*) as new_count1 from sales_info where dt='2019-04-26'
union all
select count(*) as new_count2 from sales_info where dt='2019-04-26'
方法2:(报错)
select T1.new_count1,T1.new_count2 from
(
select count(*) as new_count1 from sales_info where dt='2019-04-26'
union all
select count(*) as new_count2 from sales_info where dt='2019-04-26'
)T1
报错: FAILED: Seman