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 vote215 views1 answer
Mysql_error replacement
SQL
2 votes255 views1 answer
Oracle find constraints referencing a table
SQL
17 votes285 views4 answers
Show all tables in oracle
SQL
0 vote214 views1 answer
Datagrip exec
SQL
9 votes211 views2 answers
Get first 3 letters in sql
SQL
2 votes261 views1 answer
Mysql select true or false
SQL
12 votes218 views2 answers
Delete all entries postgres
SQL
2 votes208 views3 answers
3 days back in sql server
SQL
0 vote236 views3 answers
How to increase size of column in sql
SQL
1 vote223 views1 answer
Sql pick random row
SQL