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 vote193 views2 answers
How to login to mysql as normal user in ubuntu
SQL
13 votes165 views2 answers
Display users in mysql
SQL
0 vote156 views1 answer
Job for mysql.service failed because the control process exited with error code.
SQL
0 vote177 views2 answers
How to create a table from another table in sql derby
SQL
0 vote172 views1 answer
Inspecting a column unique/distinct values in SQL
SQL
0 vote180 views1 answer
Create table in dbms cmds
SQL
1 vote171 views1 answer
DATE_SUB postgres
SQL
0 vote162 views2 answers
Insert into
SQL
10 votes176 views4 answers
Sql pagination
SQL
22 votes205 views3 answers
Sql cheat sheet
SQL