SELECT ProductName, ROUND(UnitPrice,0) as UnitPrice FROM Products
用round函数取出来整数.
http://www.w3school.com.cn/sql/sql_func_round.asp
SELECT ProductName, ROUND(UnitPrice,0) as UnitPrice FROM Products
用round函数取出来整数.
http://www.w3school.com.cn/sql/sql_func_round.asp