SQL

get two decimal places in sql server

select cast(10.3333 AS DECIMAL(10,2)) Result -- 10.33
select cast(10 AS DECIMAL(10,2)) Result -- 10.33

select cast(your_float_column as decimal(10,2))
from your_table

sql decimal to 2 places

CAST(MyNumber AS NUMERIC(18,2))

sql decimal with 2 places

ROUND(column_name,decimals)