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 vote268 views1 answer
Update top 100 sql
SQL
8 votes340 views2 answers
Default sql server port
SQL
0 vote280 views1 answer
Create or replace view postgress
SQL
0 vote329 views1 answer
Array aggre distinct postgres
SQL
20 votes297 views6 answers
Creating a table in sql
SQL
0 vote265 views1 answer
Format the money fied with comma in international system using sql
SQL
0 vote292 views2 answers
How to create a table from another table in sql derby
SQL
1 vote281 views1 answer
Timestamp in sqlite
SQL
5 votes291 views2 answers
Oracle apex debug mode
SQL
0 vote297 views1 answer
Authentication in sql server
SQL