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 vote185 views1 answer
Sql check if field is not null
SQL
5 votes194 views4 answers
Restart the psql server windows
SQL
0 vote164 views1 answer
Postgres change the name of schema
SQL
-2 votes151 views2 answers
Add auto_increment column to existing table mysql
SQL
0 vote130 views1 answer
Tsql generate rows
SQL
3 votes132 views2 answers
Pl sql escape '
SQL
0 vote144 views2 answers
Create row number in sql
SQL
2 votes136 views1 answer
Get first 2 letter in sql
SQL
0 vote146 views1 answer
Stored procedures example
SQL
0 vote147 views4 answers
How to drop all tables in sql
SQL