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 vote157 views1 answer
Sql server phone constraint
SQL
0 vote148 views1 answer
Update sqlaclehmy sqlalchemy.orm.evaluator.UnevaluatableError: Cannot evaluate BinaryExpression with operator <function like_op at 0x03CF1DF0>
SQL
0 vote131 views1 answer
Remove default constraint sql server
SQL
5 votes129 views1 answer
Ora-00054 find lock
SQL
0 vote139 views1 answer
What is delimiter in mysql
SQL
0 vote164 views1 answer
Tsql find the value and count of the item that occurs the most in a column
SQL
0 vote136 views1 answer
Oracle select invalid views
SQL
0 vote148 views1 answer
Download mysql database to excel in android studio
SQL
0 vote151 views1 answer
How to update date value in sql
SQL
11 votes148 views4 answers
Update row in mysql
SQL