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 vote201 views1 answer
Spring boot mysql connection properties
SQL
0 vote208 views1 answer
Postgres dump sql insert
SQL
0 vote198 views1 answer
Create table database in psql
SQL
0 vote200 views2 answers
How to login to mysql as normal user in ubuntu
SQL
2 votes196 views1 answer
SELECT LOCKED FROM public.databasechangeloglock WHERE ID=1
SQL
1 vote193 views1 answer
Oracle apex version view
SQL
0 vote199 views1 answer
Delete record by id sql
SQL
0 vote177 views1 answer
Oracle list chain steps
SQL
4 votes180 views1 answer
Sql group by year
SQL
0 vote221 views1 answer
Insert into table with only identity column
SQL