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

15 votes259 views4 answers
T-sql drop function if exists
SQL
0 vote288 views1 answer
Sql server synonym
SQL
1 vote449 views3 answers
Sql subquery
SQL
1 vote219 views1 answer
Oracle boolean to varchar
SQL
0 vote288 views1 answer
Rows, INSERT INTO, Returning
SQL
4 votes279 views1 answer
Data types in sql
SQL
3 votes295 views1 answer
Start mysql server linux terminal
SQL
7 votes267 views1 answer
Sql server convert string to date
SQL
1 vote285 views1 answer
Sql server delete top 1000
SQL
4 votes265 views3 answers
Copy table postgres
SQL