Multiple choice technology databases

What is the ABS SQL function used for?

  1. To return the absolute, positive value of a numeric expression.

  2. To return the average value of a numeric expression.

  3. To return the maximum value of a numeric expression.

  4. To return the minimum value of a numeric expression.

Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

The ABS() function in SQL returns the absolute (non-negative) value of a numeric expression. For example, ABS(-15) returns 15, and ABS(15) returns 15. It's commonly used for distance calculations or normalizing data.