# ROUND ## Definition(s) ### Context: [[Nexus - Google Analytics Certificate Course#5.2 Google Analytics - 5 Analyze - Module 2 - Format and Adjust Data Format and Adjust Data|Google Analytics Certificate]] #### Sub-context: [[SQL statement]] >[! Definition] >A SQL function that returns a number rounded to a certain number of decimal places ## Examples ```SQL SELECT ROUND(price*units_sold, 2) AS total_revenue FROM dvisionSales.sales ``` ## Related ## Resources ## Flashcards The below code are generated for use with [Spaced Repetition plugin](https://github.com/st3v3nmw/obsidian-spaced-repetition/) [docs](https://www.stephenmwangi.com/obsidian-spaced-repetition/) A SQL function that returns a number rounded to a certain number of decimal places @@@ [[ROUND]]