MySQL SIGN function is one of the Numeric Function which is used to return sign of the specified expression. And the return value will be either Positive (+1), Negative (-1), or Zero (0). In this article we will show you, How to find the sign of a value in MySQL using Command Prompt, and Workbench with example.
MySQL SIGN Syntax
The basic syntax of the SIGN in MySQL is as shown below:
|
1 2 |
SELECT SIGN (Numeric_Expression) FROM Source |
- If the Expression is Zero, SIGN function will return Zero as result.
- If the Numeric_Expression is Negative Number, function will return Negative One(-1) as result.
- And If the Expression is positive Number, SIGN function will return Positive One(+1) as result.
To demonstrate this SIGN Numeric function, we are going to use the below shown data
MySQL SIGN Function Example 1
The SIGN Function is used to find and return the sign of a specified value. The following MySQL query will show multiple ways to use SIGN function.
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 |
-- MySQL SIGN Function Example -- Finding Sign for Negative Value SELECT SIGN(-240.75) AS `Sign Value`; -- Finding Sign for Positive Value SELECT SIGN(125.267) AS `Sign Value`; -- Finding Sign for Zero SELECT SIGN(0) AS `Sign Value`; -- Sign of string value SELECT SIGN('125.274') AS `Sign Value`; -- Sign Example on String SELECT SIGN('MySQL') AS `Sign Value`; -- Sign Example on NULLs SELECT SIGN('NULL') AS `Sign Value`; |
From the below screenshot you can see, we used SIGN function on different values. Here, we assigned a new name to the result as ‘Sign Value’ using ALIAS Column.
and
MySQL SIGN Example 2
In MySQL, SIGN Numeric Function also allows you to check the sign value for the column data. In this example, we are going to find the sign value for all the records present in Service Grade column.
|
1 2 3 4 5 6 7 |
-- MySQL SIGN Function Example USE mysqltutorial; SELECT Product, Color, StandardCost, Sales, TaxAmt, ServiceGrade, SIGN(ServiceGrade) AS `Grade Sign` FROM `numeric functions`; |
OUTPUT
Thank You for Visiting Our Blog
Leave a Reply