Just a Web Code Solution
how to find out the sign of value using sql ?
202
SQL
0
By 9 years ago
The power of the user (%)
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 9 years ago
The power of the user (%)
The most helpful SQL solutions
how to execute select into using sql ?SQL
Click to see more ...
740
53
convert string to date sqlSQL
Click to see more ...
650
42
How to get the last record from table using sql ?SQL
Click to see more ...
566
33
create table sqlSQL
Click to see more ...
342
23
How use like using sql ?SQL
Click to see more ...
422
22
How to get the last 10 records using mysql ?SQL
Click to see more ...
320
21
rows to columns sqlSQL
Click to see more ...
271
17
insert new column into table sqlSQL
Click to see more ...
274
16
How to convert the values to lowercase using sql ?SQL
Click to see more ...
293
13
How to change a negative number to positive using sql ?SQL
Click to see more ...
228
11
- Related solutions:
- How to find out if the record is not in the another table us ...
210 1 - How to find out if the record is in the another table using ...
189 0 - How to find out if the record exists comparing two table usi ...
190 0 - How to find out if the record not exists comparing two table ...
177 0 -
Vote
3
- Latest solutions:
- create table sql
342 23 - insert new column into table sql
274 16 - rename column sql
234 3 - convert string to date sql
650 42 - get date from datetime sql
203 1 - get part of a string sql
210 0 - select year from datetime sql
222 1 - create table from select sql
256 3 - rows to columns sql
271 17 - delete table from databse sql
213 1 - Helpful solutions:
- how to execute select into using sql ?
740 53 - convert string to date sql
650 42 - How to get the last record from table using sql ?
566 33 - create table sql
342 23 - How use like using sql ?
422 22 - How to get the last 10 records using mysql ?
320 21 - rows to columns sql
271 17 - insert new column into table sql
274 16 - How to convert the values to lowercase using sql ?
293 13 - How to change a negative number to positive using sql ?
228 11
SQL
Would you like to receive an e-mail notification when new SQL solution is created?