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 vote224 views1 answer
Sql injection
SQL
2 votes243 views3 answers
Oracle show column of table
SQL
0 vote233 views1 answer
What are the advantages of MySQL when compared with Oracle?
SQL
0 vote242 views1 answer
Mysql DDL
SQL
0 vote230 views1 answer
Sql find table by name
SQL
0 vote190 views0 answer
SQL
7 votes261 views1 answer
Oracle alter sequence restart start with
SQL
0 vote231 views1 answer
Selecting Data in SQL - Select Data
SQL
7 votes240 views2 answers
Oracle sql drop index
SQL
0 vote276 views1 answer
Psql create usr
SQL