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 vote176 views1 answer
Is numeric in sql
SQL
0 vote192 views1 answer
Open postgresql.conf in centos
SQL
0 vote190 views1 answer
Create schema sql server
SQL
1 vote180 views3 answers
How to update column name in psql
SQL
0 vote177 views2 answers
Postgres default user
SQL
1 vote182 views2 answers
Mysql trim spaces
SQL
5 votes188 views3 answers
Sql max value in column
SQL
0 vote169 views1 answer
Truncate a table then insert data
SQL
0 vote178 views1 answer
Mysql random number between 1 and 100
SQL
0 vote138 views2 answers
How to combine two sql queries in one result
SQL