select 2,4,cast(2 as float) /4select a,b,cast(a as float) /b from table
CREATE TABLE test ( col1 INT , col2 INT ) GO INSERT test SELECT 2,4 UNION ALL SELECT 3,2 GO --结果保留一位小数 SELECT col1,col2,CAST(col1*1.0/col2 AS DECIMAL(18,1)) AS jg FROM test /* col1 col2 jg ---- ---- ---- 2 4 0.5 3 2 1.5 */ GO DROP TABLE test
select 2,4,cast(2 as float) /4select a,b,cast(a as float) /b from table
CREATE TABLE test
(
col1 INT ,
col2 INT
)
GO
INSERT test
SELECT 2,4 UNION ALL
SELECT 3,2
GO
--结果保留一位小数
SELECT col1,col2,CAST(col1*1.0/col2 AS DECIMAL(18,1)) AS jg
FROM test
/*
col1 col2 jg
---- ---- ----
2 4 0.5
3 2 1.5
*/
GO
DROP TABLE test