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 vote184 views1 answer
Selecting duplicates
SQL
1 vote213 views1 answer
Insert many to many sql
SQL
6 votes167 views2 answers
How to copy data in sql
SQL
1 vote223 views1 answer
Psql client write to bash variable
SQL
1 vote216 views1 answer
Homebrew install mysql
SQL
1 vote193 views1 answer
Mysql add fields
SQL
0 vote188 views1 answer
Sqlalchemy one column of two has to be not null
SQL
0 vote215 views2 answers
Mysql where in maintain order group_concat
SQL
0 vote215 views1 answer
How to make sure two tables have same exact data in sql
SQL
1 vote216 views1 answer
Mysql show long running queries
SQL