CASE
WHEN ROUND( b.BIG_RATIO * 100, 2 ) >= 0 and ROUND( b.BIG_RATIO * 100, 2 ) < 1
THEN
‘0’||to_char(ROUND( b.BIG_RATIO * 100, 2 ),‘99D99’)||‘%’
ELSE
to_char(ROUND( b.BIG_RATIO * 100, 2 ),‘99D99’)||‘%’
END AS BIG_RATIO
有几种情况
CASE
WHEN ROUND( b.BIG_RATIO * 100, 2 ) >= 0 and ROUND( b.BIG_RATIO * 100, 2 ) < 1
THEN
‘0’||to_char(ROUND( b.BIG_RATIO * 100, 2 ),‘99D99’)||‘%’
ELSE
to_char(ROUND( b.BIG_RATIO * 100, 2 ),‘99D99’)||‘%’
END AS BIG_RATIO
有几种情况