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

16 votes345 views2 answers
Sql exists
SQL
0 vote366 views1 answer
View psql output in horizontal scrolling
SQL
0 vote351 views1 answer
Postgresql delete type
SQL
1 vote324 views1 answer
Base nosql
SQL
5 votes298 views1 answer
Alter table default value mysql
SQL
3 votes341 views2 answers
Sql paging query
SQL
9 votes348 views5 answers
Sql delete duplicate rows but keep one
SQL
0 vote352 views1 answer
Excel vba import data to sql server
SQL
1 vote369 views1 answer
Mysql text to decimal
SQL
1 vote345 views1 answer
Select from describe sql
SQL