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 vote317 views3 answers
Query string not ending with with vowels
SQL
3 votes318 views1 answer
Force using index plsql
SQL
2 votes344 views1 answer
Sql server find columns list in tables
SQL
1 vote305 views1 answer
User privileges postgresql information_schema
SQL
2 votes276 views1 answer
Oracle sql drop column if exists
SQL
1 vote324 views1 answer
How to get previous year from sysdate in oracle
SQL
6 votes350 views3 answers
Create database mysql utf8
SQL
2 votes362 views1 answer
Postgresql group by month and year
SQL
0 vote334 views1 answer
Shortcut run sql pgadmin
SQL
1 vote321 views1 answer
Hexadec to sql REDSHIFT
SQL