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 vote140 views1 answer
Systemverilog unique constraint unique values
SQL
0 vote148 views1 answer
Mysql group by range
SQL
1 vote162 views1 answer
Add sequence postgres
SQL
3 votes138 views1 answer
Mysql set field unique
SQL
0 vote131 views1 answer
Postgres data location
SQL
1 vote164 views1 answer
Select not matching data with join table
SQL
0 vote143 views1 answer
Laravel eloquent get generated sql
SQL
6 votes141 views2 answers
Join vs union
SQL
7 votes147 views3 answers
Convert ansi sql
SQL
0 vote128 views2 answers
Sql count number of rows after group by
SQL