Sql

Search

nullif postgresql

SELECT
	NULLIF (1, 1); -- return NULL

SELECT
	NULLIF (1, 0); -- return 1

SELECT
	NULLIF ('A', 'B'); -- return A
Code language: SQL (Structured Query Language) (sql)

Comment

PREVIOUS	NEXT

Code Example
Sql :: print integer and string in SQL
Sql :: sql count null values in all columns
Sql :: mysql add column to table
Sql :: sql date format dd-mm-yyyy
Sql :: primary key multiple
Sql :: empty table sqlite
Sql :: update join sql
Sql :: show database cmd
Sql :: adding generated time in row mysql workbench
Sql :: version and edition of SQL Server Database Engine
Sql :: stored procedure to delete data from table in mysql
Sql :: mysql get first n characters of string
Sql :: spring boot working with sql database connection
Sql :: between from sql
Sql :: select distinct after join
Sql :: raiserror nowait sql server
Sql :: postgres update with if condition query
Sql :: sql set
Sql :: check database sessions oracle
Sql :: sql precent format
Sql :: mysql limit
Sql :: q operator in plsql
Sql :: mysql find duplicates
Sql :: sql rtrim
Sql :: sql server split string last
Sql :: PL SQL VARRAY of records
Sql :: sql pass table name as variable
Sql :: mysql not equal
Sql :: oracle create table primary key
Sql :: not regexp_like in oracle

Search

SQL

nullif postgresql

ADD CONTENT