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 vote122 views1 answer
How to get data between a last week in mysql
SQL
1 vote140 views1 answer
Describe table in sql
SQL
0 vote126 views2 answers
How to update date in oracle
SQL
10 votes128 views2 answers
Oracle alter sequence nextval
SQL
0 vote144 views1 answer
Helptext in sql
SQL
1 vote118 views1 answer
Sql insert for each distinct value
SQL
0 vote171 views1 answer
AddEntityFrameworkSqlite
SQL
0 vote128 views1 answer
Oracle query to see what scema i am working in
SQL
2 votes128 views2 answers
How to get the date diff of 2 dates in the same fieldin sql server
SQL
3 votes163 views4 answers
Mysql create table from select statement
SQL