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

4 votes203 views1 answer
Sql query to make a existing column auto increment
SQL
-1 vote217 views4 answers
Restart mysql server ubuntu
SQL
0 vote212 views2 answers
Execute stored procedure without db set
SQL
0 vote191 views2 answers
Nosqlbooster query other collection
SQL
0 vote198 views1 answer
Sql server current time without date
SQL
0 vote208 views1 answer
How to put 0 or 000 depending IDCustomer length in sql server
SQL
0 vote203 views1 answer
Oracle show grants on table
SQL
1 vote262 views4 answers
How to check table in postgresql from terminal
SQL
0 vote202 views2 answers
Plsql regex match whole word
SQL
4 votes207 views2 answers
Mysql show indexes on table
SQL