SQL find out sign value sql - Net-Raft.com

Welcome aboard! We are happy you are here and wish you good net-raft!




Just a Web Code Solution
join us

how to find out the sign of value using sql ?


 157

SQL


0

select SIGN(-5) from table_rest; // the result is: -1
select SIGN(0) from table_rest; // the result is: 0
select SIGN(5) from table_rest; // the result is: 1


By        
The power of the user (%)
62%



The most helpful SQL solutions

how to execute select into using sql ?how to execute select into using sql ?SQL

Click to see more ...

  699     53

convert string to date sqlconvert string to date sqlSQL

Click to see more ...

  613     42

How to get the last record from table using sql ?How to get the last record from table using sql ?SQL

Click to see more ...

  529     33

create table sqlcreate table sqlSQL

Click to see more ...

  310     23

How use like using sql ?How use like using sql ?SQL

Click to see more ...

  387     22

How to get the last 10 records using mysql ?How to get the last 10 records using mysql ?SQL

Click to see more ...

  281     21

rows to columns sqlrows to columns sqlSQL

Click to see more ...

  238     17

insert new column into table sqlinsert new column into table sqlSQL

Click to see more ...

  236     16

How to convert the values to lowercase using sql ?How to convert the values to lowercase using sql ?SQL

Click to see more ...

  247     13

How to change a negative number to positive using sql ?How to change a negative number to positive using sql ?SQL

Click to see more ...

  196     11

Welcome aboard!
We are happy you are here and
wish you good net-raft!