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 vote105 views1 answer
Check psql validity function
SQL
1 vote104 views1 answer
Find a column in all tables postgres
SQL
6 votes155 views2 answers
How to get last element sql
SQL
0 vote105 views1 answer
Show create table in postgresql
SQL
13 votes103 views2 answers
Get date from now() mysql
SQL
0 vote98 views1 answer
Sql check for null and empty string
SQL
0 vote101 views1 answer
Execut sql python
SQL
1 vote107 views1 answer
Input in mysql
SQL
7 votes111 views2 answers
Html to react converter
SQL
0 vote99 views1 answer
Replace \n sql
SQL