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 vote315 views1 answer
Error code 1241 mysql
SQL
1 vote294 views1 answer
Sql delete row with auto increment
SQL
1 vote307 views1 answer
Find a column in all tables postgres
SQL
1 vote319 views1 answer
Sql server loop over query
SQL
5 votes284 views1 answer
Oracle asynchronous query
SQL
13 votes243 views2 answers
Oracle all source
SQL
7 votes286 views4 answers
Database dump mysql command
SQL
0 vote294 views1 answer
User, group, or role 'open' already exists in the current database.
SQL
0 vote324 views1 answer
How to enable mysql 5.7 root user password on linux
SQL
1 vote300 views1 answer
Oracle stop
SQL