sql²éѯ СÊýÎÊÌâ

Êý¾Ý¿âÖÐÒ»¸ö×ֶεÄÖµÊÇ19.120£¬ÈçºÎ²éѯ¿ÉÒÔÈýá¹û¼¯ÖиÃ×ֶεÄֵΪ19.12£¬Ò²¾ÍÊÇÖ»ÏÔʾÁ½Î»Ð¡Êýµã

---

SQL code:
dec(18,2)

---

SQL code:
cast(col as dec(18,2))

---

SQL code:
select cast(col as dec(18,2)) from tb

---

SQL code:

cast(col as dec(18,2))



¶¥£¡

---

SQL code:


select cast(col as dec(18,2))

---

SQL code:
SELECT CAST(lzzf_area AS dec(18, 2)) AS Expr1
from lowHourse

Ö´ÐÐÕâ¶Î´úÂëµÄʱºò³ö´í£º²»ÄܶÔdecimalµ÷Ó÷½·¨

---

SQL code:

select cast(lzzf_area as decimal(18,2))AS Expr1
from lowHourse

---

ÒýÓÃ

SQL codeSELECTCAST(lzzf_areaASdec(18,2))AS Expr1