clear markdown compare help donate or buy diddy dollings comments/suggestions/bugs a leap of faith? bible365
clear markdown donate comments/suggestions/bugs a leap of faith? bible365 diddy dollings
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0. 648488 fiddles created (15212 in the last week).

create table t ( f1 numeric(10,3), f2 numeric(10,3), f3 numeric(10,3), f4 numeric(10,3) )
 hidden batch(es)


insert into t values ( 60, 60, 60, 60 );
1 rows affected
 hidden batch(es)


select * from t;
F1 F2 F3 F4
60.000 60.000 60.000 60.000
 hidden batch(es)


select f1*f2*f3*60 as product from t union all select f1*f2*f3*cast(f4 as integer) as product from t;
PRODUCT
12960000.000000000
12960000.000000000
 hidden batch(es)