SQL ROUND() Function
The ROUND() Function
The ROUND() function is used to round a numeric field to the number of
decimals specified.
SQL ROUND() Syntax
SELECT ROUND(column_name,decimals) FROM table_name
|
| Parameter |
Description |
| column_name |
Required. The field to round. |
| decimals |
Required. Specifies the number of decimals to be
returned. |
SQL ROUND() Example
We have the following "Products" table:
| Prod_Id |
ProductName |
Unit |
UnitPrice |
| 1 |
Jarlsberg |
1000 g |
10.45 |
| 2 |
Mascarpone |
1000 g |
32.56 |
| 3 |
Gorgonzola |
1000 g |
15.67 |
Now we want to display the product name and the price rounded to the nearest
integer.
We use
the following SELECT
statement:
SELECT ProductName, ROUND(UnitPrice,0) as UnitPrice FROM Products
|
The result-set will look like this:
| ProductName |
UnitPrice |
| Jarlsberg |
10 |
| Mascarpone |
33 |
| Gorgonzola |
16 |
Whether you're new to XML or already an advanced user, the user-friendly views
and powerful entry helpers, wizards, and debuggers in XMLSpy are designed to
meet your XML and Web services development needs from start to finish.
- XML editor
- Graphical XML Schema / DTD editors
- XSLT 1.0/2.0 editor, debugger, profiler
- XQuery editor, debugger, profiler
- Support for Office Open XML (OOXML)
- Graphical WSDL editor & SOAP debugger
- Java, C#, C++ code generation
- And much more!
Download a fully functional free 30-day trial today!
|
