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 vote206 views1 answer
Get duplicate entry sql
SQL
0 vote219 views1 answer
Postgresql get diff between two dates in Months
SQL
0 vote206 views1 answer
Sqlalchemy.exc.OperationalError:
SQL
0 vote209 views1 answer
Write a PL/SQL to print even numbers upto 100.
SQL
0 vote199 views1 answer
Renombrar tabla mysql
SQL
1 vote214 views1 answer
Mysql not supported auth mode
SQL
2 votes219 views1 answer
Oracle apex who is connected
SQL
0 vote197 views1 answer
How to make case insensitive in sql
SQL
2 votes203 views1 answer
Create table with primary key
SQL
0 vote210 views1 answer
Sql cmd no truncate
SQL