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 vote345 views1 answer
Update database collation in postgresql
SQL
1 vote375 views1 answer
OstgreSQL version
SQL
1 vote363 views1 answer
What is int in mysql
SQL
14 votes376 views1 answer
Excel
SQL
5 votes370 views2 answers
Get number of columns sql
SQL
4 votes366 views1 answer
Oracle session date format
SQL
6 votes404 views2 answers
Oracle trigger
SQL
0 vote339 views3 answers
Convert sql query to python pandas
SQL
0 vote355 views1 answer
Mysql export search results
SQL
0 vote426 views1 answer
Split first name and last name in sql
SQL