Numeric functions

This lesson uses the unmodified DDI_SQL_Training dataset v1.0.0 on SQL Server 2019 or later. Round calculated prices with an explicit precision.

Run the example

SELECT TOP (3) ProductID, ListPrice,
       ROUND(ListPrice * 1.10, 2) AS PriceWithTenPercent
FROM dbo.Products
ORDER BY ProductID;

Read it step by step

1. ListPrice is decimal(10,2), so the multiplication uses exact decimal arithmetic.
2. ROUND(..., 2) rounds the computed result to two decimal places; its displayed scale can still be wider.
3. ORDER BY ProductID identifies the first three products consistently.

Check the result

These are calculated prices, not updates to ListPrice.

Practice

For Products 1 and 2, show the absolute difference between ListPrice and 50.

SELECT ProductID, ABS(ListPrice - 50) AS DistanceFrom50
FROM dbo.Products
WHERE ProductID IN (1, 2)
ORDER BY ProductID;