The ROUND() function is used to round a numeric field to the number of decimals specified.
We have the following "Products" table:
Now we want to display the product name and the price rounded to the nearest integer.
We use the following SELECT statement:
The result-set will look like this:
Your Query was successfully sent!