Drag the edges to resize the window.

Code Editor

Query Results

Run a query to see results.

Database Schema

Schema undefined.
Learn
Aggregate Functions

Round

By default, SQL tries to be as precise as possible without rounding. We can make the result set easier to read using the ROUND function.

ROUND function takes two arguments inside the parenthesis:

  • a column name
  • an integer

It rounds the values in the column to the number of decimal places specified by the integer.

SELECT ROUND(price, 0) FROM fake_apps;

Here, we pass the column price and integer 0 as arguments. SQL rounds the values in the column to zero decimal places in the output.

Report a Bug
If you see a bug or any other issue with this page, please report it here.