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 vote172 views1 answer
Sql query inline if
SQL
1 vote339 views1 answer
Foreign key in oracle sql developer
SQL
0 vote149 views1 answer
Will graphql replace sql
SQL
8 votes188 views1 answer
Mysql dump restore
SQL
0 vote157 views1 answer
Is not sql
SQL
2 votes152 views2 answers
How to rename column name in sql server using query
SQL
2 votes145 views1 answer
Cast string to datetime mysql
SQL
0 vote203 views1 answer
Show mysql account privilleges
SQL
0 vote229 views1 answer
Mysql update all record removing 2 hours from column
SQL
0 vote153 views1 answer
Mysql query problems and solutions
SQL