Informatics Practices
What will be returned by the given query ?
SELECT Sign(26);
- 1
- -1
- 0
- none of these
SQL Queries
2 Likes
Answer
1
Reason — The SIGN() function is used to determine the sign of a given number. It returns 1 if the number is positive, -1 if the number is negative, and 0 if the number is zero. In this query, SIGN(26) represents a positive number. Therefore, it will return 1 as the output.
Answered By
1 Like
Related Questions
To remove the leading and trailing space from data values in a column of MySQL Table, we use
- Left()
- Right()
- Trim()
- Ltrim()
What will be returned by the given query ?
SELECT Round(153.669, 2);- 153.6
- 153.66
- 153.67
- 153.7
What will returned by the given query ?
SELECT Truncate(15.79, -1), Truncate(15.79, 0), Truncate(15.79, 1);- 15 15 15.7
- 10 15.7 15.9
- 10 15 15.7
- 10 10 15.9
What will be returned by the given query ?
SELECT month('2020-05-11');- 5
- 11
- May
- November