SQL的截取 - MS-SQL Server / 基础类

数据库中price（列）是 ：123600
现要弄成：12.40万 或者 12.30万

---

SQL code:
select ltrim(cast(price*10/10000/10.0 as dec(18,2)))+'万'
from tb

---

select 123600.0/10000

---------------------------------------
12.3600000

(1 行受影响)

---

SQL code:
select ltrim(cast(round(price/10000.0,1) as dec(18,2)))+'万' as price from [tb]

---

SQL code:
select ltrim(cast(round(price/10000.0,1) as dec(18,2)))+'万' as price from tb

---

SQL code:
ltrim(cast(round(price/10000.0,2) as dec(18,2))) as price