sql bild in function 1

sql bild in function

SELECT Name,
       ABS(500 - ReorderPoint) ReorderPointDeviation
FROM   production.Product
WHERE  ABS(500 - ReorderPoint) > 200

Here is what the above code is Doing:
1. We’re selecting the Name and ReorderPointDeviation columns from the Product table.
2. We’re filtering the results to only include rows where the absolute value of 500 minus the ReorderPoint is greater than 200.

Similar Posts