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 vote265 views1 answer
Regex mongoose
SQL
0 vote225 views1 answer
Como hacer una consulta de un registro que no esta en una tabla en mysql
SQL
1 vote142 views1 answer
Insert into sql
SQL
0 vote204 views1 answer
10000000000000000000 am to meters
SQL
0 vote213 views2 answers
List all constraints in postgres
SQL
0 vote161 views1 answer
Postgres delete where id in
SQL
0 vote197 views2 answers
How to display enum value sql server
SQL
0 vote203 views1 answer
Power bi dax add related shows column but not working
SQL
0 vote271 views1 answer
Jooq replace
SQL
13 votes188 views2 answers
Check if value is null mysql
SQL