Returns the absolute value.
Syntax
ABS(x)Example
Enter values below to update the example in real time.
employee_id→sales_actual→sales_target→gap→sales_records→-- 목표 대비 차이 절댓값
SELECT employee_id, ABS(sales_actual - sales_target) AS gap
FROM sales_records;