By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table trailing_zeros (
c1 float,
c2 decimal(15,2))
insert into trailing_zeros values (1000.00,1000.00), (100.50, 100.50), (1.20, 1.20)
select * from trailing_zeros
| c1 | c2 |
|---|---|
| 1000 | 1000.00 |
| 100.5 | 100.50 |
| 1.2 | 1.20 |