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

1 vote166 views1 answer
Oracle list data files
SQL
0 vote214 views1 answer
Bash block size ls /var/lib/mysql
SQL
0 vote209 views1 answer
Postgres extract number from string
SQL
5 votes180 views3 answers
Db begintransaction laravel
SQL
13 votes146 views6 answers
Restart postgresql
SQL
1 vote183 views1 answer
OSError: mysql_config not found
SQL
-1 vote112 views1 answer
Mysql how to set update or create
SQL
4 votes191 views2 answers
Postgresql float data type
SQL
1 vote189 views1 answer
VERIFY INDEXES IN SQL ORACLE
SQL
0 vote176 views1 answer
Sql server current time without date
SQL