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 vote409 views1 answer
Stratified sampling sql
SQL
1 vote327 views2 answers
Into sql
SQL
0 vote422 views1 answer
Comparing with today and yesterday record in sql query
SQL
4 votes363 views1 answer
Phone number sql
SQL
0 vote351 views2 answers
Null value in column violates not-null constraint
SQL
3 votes387 views1 answer
Two select sql
SQL
0 vote376 views1 answer
Count in sql and diff
SQL
0 vote357 views1 answer
Sql server cannot create database diagram
SQL
0 vote374 views1 answer
Postgresql select join by date - Join rows where a timestamp value is equal to midnight of the date
SQL
0 vote389 views1 answer
Nodejs sql get one to many relationship as array
SQL