Search
 
SCRIPT & CODE EXAMPLE
 

SQL

postgresql if 0 then 1

-- returns the greatest value, in case 1
select greatest( 0, 1 )
-> 1
-- it also works with null values
select greatest( null, 1 )
-> 1
Comment

PREVIOUS NEXT
Code Example
Sql :: ora-01950 no privileges on tablespace 
Sql :: select dba users oracle 
Sql :: how to create index mysql 
Sql :: postgres connection string 
Sql :: mysql monthname 
Sql :: grant permission in postgres 
Sql :: get columns number sql 
Sql :: stop psql server windows 
Sql :: oracle drop chain step 
Sql :: how to add unique constraint in mysql table 
Sql :: SQL Integer devision 
Sql :: mysql dump mysql db cli 
Sql :: sql getdate minus 1 day without time 
Sql :: mysql delete binlog 
Sql :: sql find column name like 
Sql :: psql autocomplete for mac brew install 
Sql :: mysql random number between 1 and 100 
Sql :: sql server utc to local 
Sql :: pentaho + pasar de excel a sql 
Sql :: python how to connect to sql server 
Sql :: delete all rows from table sql 
Sql :: sql server list user permissions 
Sql :: oracle pl/sql prevent sql injection 
Sql :: truncate left characters mysql 
Sql :: mysqldump password 
Sql :: show all users in mysql 
Sql :: What is localhost IP and MySql default port no. 
Sql :: import .sql into postgres db command 
Sql :: create column sql 
Sql :: sql alchemy with azuresql server 
ADD CONTENT
Topic
Content
Source link
Name
7+9 =