Postgres isnull

Postgresql isnull with max

SELECT coalesce(field, 'Empty') AS field_alias

Postgres isnull

SELECT
    id,
    first_name,
    last_name,
    email,
    phone
FROM
    contacts
WHERE
    phone IS NULL; 
    
 
 Code language: SQL (Structured Query Language) (sql)

Source: postgresqltutorial.com

Similar codes

0 vote185 views1 answer
Group by two columns postgres
SQL
0 vote189 views1 answer
Mysql group by derived column
SQL
-1 vote194 views2 answers
SQL SELECT TOP Equivalent in oracal
SQL
1 vote256 views1 answer
Error cs1061 'dbcontextoptionsbuilder' does not contain a definition for 'usesqlserver'
SQL
0 vote204 views1 answer
Mysql insert into select with recursive
SQL
0 vote180 views1 answer
How should I pass a table name into a stored proc?
SQL
0 vote201 views1 answer
Least spark sql
SQL
4 votes180 views2 answers
Dbms_scheduler stop job
SQL
5 votes275 views4 answers
Sql check
SQL
4 votes185 views1 answer
Find tables with column name in sql
SQL