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)

Source: postgresqltutorial.com

Similar codes

1 vote238 views3 answers
Union in sql
SQL
0 vote219 views1 answer
Nueva tabla mysql
SQL
0 vote247 views1 answer
One table with another
SQL
12 votes236 views3 answers
Install sqlite driver ubuntu
SQL
2 votes223 views6 answers
In in sql
SQL
0 vote231 views1 answer
Add sqlcmd to path linux
SQL
0 vote231 views1 answer
Sql clear table
SQL
17 votes243 views6 answers
Change column name in sql
SQL
0 vote244 views1 answer
Postgresql create query
SQL
0 vote231 views1 answer
Mostrar datos de tablas relacionadas mysql kjava
SQL