select a,b,cast(cast(a as float)/cast(b as float) as numeric(5,3)) as c from A
create table a(a varchar(10),b varchar (10)) insert into a select '1','2' insert into a select '2','32' insert into a select '11','2' insert into a select '123','21' insert into a select '14','2'select a,b,cast(cast(a as dec(6,1))/cast(b as dec(6,1)) as dec(6,1)) as c from a order by c descdrop table a
from A
insert into a select '1','2'
insert into a select '2','32'
insert into a select '11','2'
insert into a select '123','21'
insert into a select '14','2'select a,b,cast(cast(a as dec(6,1))/cast(b as dec(6,1)) as dec(6,1)) as c from a order by c descdrop table a