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

3 votes108 views3 answers
Into in sql
SQL
1 vote106 views2 answers
Sql example query
SQL
5 votes118 views1 answer
Ora-00054 find lock
SQL
9 votes124 views3 answers
Mysql show table column full description
SQL
0 vote115 views1 answer
Désinstaller postgresql linux
SQL
0 vote124 views1 answer
Mysql count with two joins
SQL
0 vote113 views2 answers
Which MySQL statement is used to delete data from a database
SQL
27 votes115 views5 answers
Mysql set password for user
SQL
23 votes107 views6 answers
ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
16 votes138 views1 answer
Sqlserver add column to table
SQL