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

1 vote326 views2 answers
Oracle list partitioned tables
SQL
1 vote329 views1 answer
Rermove categories woocommerce sql
SQL
0 vote310 views1 answer
Show function mysql
SQL
1 vote341 views1 answer
Adding indexing on a db model in mysql using sequelize
SQL
3 votes429 views1 answer
Oracle cannot access v$session
SQL
3 votes331 views3 answers
C# sql select
SQL
0 vote324 views1 answer
Select max salary from each department in sql
SQL
0 vote324 views1 answer
Mysql wsrep ls
SQL
2 votes360 views1 answer
How to select from mssql
SQL
0 vote341 views1 answer
Mariadb cast null to 0
SQL