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 vote319 views1 answer
Array aggre distinct postgres
SQL
0 vote288 views1 answer
Group by join columns per table
SQL
1 vote264 views2 answers
Mysql does sentance contain word
SQL
0 vote287 views1 answer
Sql query to find difference between total no. of rows and distinct rows in sql server
SQL
8 votes265 views3 answers
Mysql alter table add index
SQL
0 vote270 views1 answer
Sql find table by name
SQL
6 votes321 views6 answers
Rename column postgres
SQL
0 vote313 views1 answer
Show all sequences postgres
SQL
0 vote273 views1 answer
FIND AVERAGE SALARY EARNER IN SQL
SQL
3 votes255 views1 answer
Oracle wait
SQL