SQL code?123select a,max(maxvalue)maxvalue from(select *,maxvalue=(select max(col) from(select a.b[col] union all select a.c union all select a.d union all select a.e union all select a.f……
select a,max(maxvalue)maxvalue from( select *,maxvalue=(select max(col) from(select a.b[col] union all select a.c union all select a.d union all select a.e union all select a.f)t) from tb a )tt group by a
表示没看懂卤煮的意思
select a,max(b)b,max(c)c,max(d)d,max(e)d,max(f)f from tb group by a
22,210
社区成员
121,726
社区内容
加载中
试试用AI创作助手写篇文章吧