Note that all the total values have two decimal digits. In the total column above, we can see the result of the ROUND() function. The result of this query is shown below: date the total column) the second one is called precision and indicates the number of decimal digits we want to maintain in the rounded number. The first one is the numeric value to be rounded (i.e. We can see that the ROUND() function receives two parameters. Suppose we want a report showing all the sales, but we only want a maximum of 2 decimal digits in the total column. If we look at the column total in the sales table above, we can see some records where the value has 3 decimal digits. Let’s start by showing a simple query using the ROUND() function in Standard SQL. Some of the products (such as eggs or vegetables) are sold based on weight in this case, the quantity column records the number of kilos sold, which can include decimal digits. This table records sales data for a small marketplace. We will show several example queries using the ROUND() function, but first we will introduce a sample SQL table called sales. The ROUND function in SQL is used to round a given number to the nearest integer or to a certain decimal place. It covers both basic and advanced SQL functions, equipping you with everything you need to start using them to process numerical, text, and other types of data in SQL databases. If you’re looking for a comprehensive course about functions in SQL, check out our interactive course on Standard SQL Functions. There are a lot of functions in SQL, and every SQL database provides a different set of functions. You can call a function in the SELECT list of columns, in the WHERE condition, or in any other place of the query where a value must be provided. Other functions like MAX() (which returns the largest value) and MIN() (which returns the smallest value) process numerical data you can learn more about these functions in the article What Are the SQL MIN() and MAX() Functions?Ī function can be called in a SQL query whenever you need to provide a value. a word, sentence, etc.) as an argument and returns part of this string.
For example, the SUBSTRING() function receives a character string (i.e.
#Squeed round code#
To understand what this means, let’s talk about functions.Ī function is a predefined piece of code that transforms its arguments into a result. (Spoiler alert: If you guessed that it rounds a number to a certain decimal place, you’re right! Read on to find out more.) SQL Standard FunctionsĮach SQL database (PostgreSQL, MySQL, Oracle, SQL Server among others) has a set of built-in functions. In this article, we will use practical examples to explain how the ROUND() function works. Modern relational databases offer many built-in functions that extend the capabilities of SQL. Need to round numeric results in SQL? The ROUND() function is here to do the job.
0 kommentar(er)
