我有下面的查询,我正在尝试连接两个分组列的语句。
with ex as (
select name, title,
max(case when special = 'super' then max_power end ) as Super,
max(case when special = 'awesome' then max_power end) as Awesome
from mytable
group by name, title)
inner join (select name, title,
min(case when special = 'super' then max_power end) as Super,
min(case when special = awesome' then max_power end) as Awesome
from mytable mt
group by name, title) t2
on t2.title = ex.title;
在语句“inner”“join”(“in”)附近出现错误“cannot recognize input”
1条答案
按热度按时间0yycz8jy1#
不知道你想做什么,但cte后面应该有另一个cte或a
select
,insert
.你可以用
使用
union all
如果列名必须相同。