17,086
社区成员
发帖
与我相关
我的任务
分享
trim(GREATEST(lpad(' ' || a,20,' '),lpad(' ' || b,20,' '),lpad(' ' || c,20 ,' ')))
trim(GREATEST(lpad(a,20,' '),lpad(b,20,' '),lpad(c,20 ,' ')))
SELECT deminid,ammountid,ammountvalue,
greatest(deminid,ammountid,ammountvalue)
FROM test1