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 votes148 views1 answer
Oracle show error line number
SQL
0 vote154 views2 answers
Connect to mysql server mac terminal
SQL
3 votes156 views1 answer
Mysql insert on dupèlicate
SQL
0 vote144 views1 answer
T-SQL MERGE with condition what is not matched?
SQL
0 vote147 views1 answer
Postgres float to int
SQL
-1 vote166 views1 answer
Install mysql 5.7 ubuntu 20.04
SQL
0 vote146 views1 answer
What alter does in db
SQL
0 vote245 views3 answers
Osx stop mysql service
SQL
0 vote142 views1 answer
Allow all local clients (local socket connections) to connect to the kodekloud_db1
SQL
15 votes165 views6 answers
Laravel db transaction
SQL