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 vote176 views2 answers
SQL SELECT TOP Equivalent in oracal
SQL
0 vote189 views1 answer
Datagrip exec
SQL
11 votes171 views2 answers
Having in sql
SQL
0 vote167 views1 answer
Mssql now diff 90 day
SQL
3 votes184 views4 answers
Psql list tables in schema
SQL
0 vote211 views1 answer
Convert multiple columns to ROws in sql server
SQL
0 vote209 views1 answer
Retornar apenas o ano mysql date
SQL
1 vote168 views2 answers
Postgresql get difference in hours between two dates
SQL
2 votes236 views3 answers
Postgres create view
SQL
2 votes131 views1 answer
Latest record in sql
SQL