mysql select 2 decimal places code example
Example 1: sql limit decimal places
SELECT CAST(ROUND(125.025000, 2) AS NUMERIC(36,2))
returns: 125.03
Example 2: round decimal mysql
round(column)
SELECT CAST(ROUND(125.025000, 2) AS NUMERIC(36,2))
returns: 125.03
round(column)