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 vote136 views1 answer
Postgresql port 5432 not open
SQL
22 votes117 views3 answers
How to join three tables in sql using joins
SQL
9 votes107 views4 answers
How to remove duplicate in sql
SQL
0 vote139 views1 answer
Postgres docs /copy metacomand
SQL
7 votes108 views1 answer
Postgres base size
SQL
0 vote60 views1 answer
Oracle sql developer script output limit
SQL
28 votes108 views4 answers
Show tables mysql
SQL
0 vote103 views1 answer
Set a default value for a column in sqlite
SQL
13 votes132 views3 answers
Sql select from multiple tables without join
SQL
-1 vote141 views2 answers
Sql truncate number
SQL