Articles/SQL

ROUND() in MySQL — How It Works

What the MySQL ROUND() function does, with an example.

Published October 21, 2026

ROUND() rounds a number to a specified number of decimal places.

Key points

  • Part of standard SQL functions available in MySQL for working with query results

Example

SELECT ROUND(19.9567, 2);  -- 19.96
More SQL articles