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 vote186 views1 answer
Insert or update cassandra
SQL
0 vote198 views1 answer
Sql select inside select sub query
SQL
0 vote197 views1 answer
Sql server select ignore dupplicates
SQL
8 votes196 views2 answers
Mysql grant all privileges to user from any host
SQL
10 votes192 views1 answer
User_dependencies
SQL
0 vote209 views2 answers
Dumping sql table
SQL
1 vote219 views1 answer
Oracle select row max date
SQL
0 vote197 views1 answer
How to use group_concat in sql server
SQL
0 vote244 views1 answer
How to pass list as parameter in SQL query
SQL
0 vote234 views2 answers
Create more than 1 tables with references to each other in sqlite3
SQL