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 vote279 views1 answer
TSQL convert csv to table
SQL
0 vote264 views1 answer
Criteria builder select subset of column
SQL
-1 vote288 views4 answers
Postgres between dates
SQL
1 vote283 views1 answer
How to select multiple columns from different tables in mysql
SQL
0 vote281 views1 answer
T sql cursor tr
SQL
0 vote268 views2 answers
Getting customers with no orders sql
SQL
6 votes265 views2 answers
Sql display max value
SQL
0 vote281 views1 answer
Mysql sql.gz
SQL
0 vote286 views2 answers
Dbms transaction tutorialspoint
SQL
0 vote291 views1 answer
Show the colums of table sql
SQL