练习题1-1-1 :多列数据的最大值
-- 求x,y和z中的最大值
select key,
case
when case
when x<y
then y
else x
end<z
then z
else case
when x<y
then y
else x
end
end
as greatest
from Greatests;
-- 转换成行格式后使用MAX函数
select key,max(col) as greatest
from(
select key,x as col
from Greatests
union