Calculating the absolute value
The Shipments table contains some bad data. There was a problem with the scales, and the weights show up as negative numbers. In this exercise, you will write a query to convert all negative weights to positive weights.
Deze oefening maakt deel uit van de cursus
Intermediate SQL Server
Oefeninstructies
Write a query that converts all the negative values in the DeliveryWeight column to positive values.
Praktische interactieve oefening
Probeer deze oefening eens door deze voorbeeldcode in te vullen.
-- Return the absolute value of DeliveryWeight
SELECT DeliveryWeight,
___(___) AS AbsoluteValue
FROM Shipments