select * from user_tab where user_column<>round(user_column,1); |
round 函数测试:
select round(100.1, 0) from dual; -- 100 | |
select round(100.5, 0) from dual; -- 101 | |
select round(100.9, 0) from dual; -- 101 | |
select round(100.01, 1) from dual; -- 100 | |
select round(100.05, 1) from dual; -- 100.1 | |
select round(100.09, 1) from dual; -- 100.1 | |
select round(101, -1) from dual; -- 100 | |
select round(105, -1) from dual; -- 110 | |
select round(109, -1) from dual; -- 110 | |
select round(110, -2) from dual; -- 100 | |
select round(150, -2) from dual; -- 200 | |
select round(190, -2) from dual; -- 200 |