TheABS()function in SQL returns theabsolute valueof a given number, effectively measuring itsdistance from zero.
Example Usage:
sql
SELECT ABS(-50), ABS(50);
Result:
50 | 50
This function ensures that numbers arealways positive, regardless of their original sign.
Why Other Options Are Incorrect:
Option A (CONCAT) (Incorrect):Used tocombine strings(not numbers).
Option B (LOWER) (Incorrect):Converts text tolowercase, not numerical operations.
Option C (FROM) (Incorrect):Part of SELECT FROM queries,not a function.
Thus, the correct choice isABS(), which computes the absolute value of a number.
[Reference:SQL Numeric Functions​., ]
Contribute your Thoughts:
Chosen Answer:
This is a voting comment (?). You can switch to a simple comment. It is better to Upvote an existing comment if you don't have anything to add.
Submit