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 vote282 views1 answer
Updating database in sql
SQL
4 votes290 views4 answers
Remove duplicate old value in mysql
SQL
0 vote287 views2 answers
Coursera spark sql max count
SQL
1 vote265 views1 answer
Blob datatype in mysql
SQL
0 vote272 views1 answer
How to check database engine in mysql
SQL
9 votes262 views1 answer
No sql
SQL
0 vote263 views1 answer
SQL Server rename foreign key constraint
SQL
12 votes251 views1 answer
Docker mysql random root password
SQL
0 vote266 views1 answer
Ver usuarios mysql
SQL
15 votes262 views6 answers
Drop foreign key mysql
SQL