Question

0.556显示56% 0.3显示成30% sql语句怎么写？

Answer 1

MS SQL
SELECT LTRIM(convert(numeric(2,0),0.556*100))+'%',LTRIM(convert(numeric(2,0),0.3*100))+'%'
-----结果
56% 30%

Answer 2

select round(0.556,2)*100 || '%' from dual;
select round(0.3,2)*100 || '%' from dual;

Answer 3

select round(字段,2)*100 || '%' from 表名;

Answer 4

select round(0.556,2)*100 || '%' from dual;