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 vote190 views1 answer
Oracle shrink table
SQL
1 vote206 views1 answer
Tsql replace value in json
SQL
1 vote228 views3 answers
Default password of mysql
SQL
0 vote199 views1 answer
Order by with where clause in mysql
SQL
0 vote185 views1 answer
Django how to get query result count
SQL
0 vote204 views1 answer
Buscar nombre de columna en todas las tablas sql server
SQL
3 votes295 views3 answers
Mysql get table size
SQL
3 votes212 views1 answer
Force using index oracle
SQL
0 vote202 views1 answer
Drop column from table if exist on live server mysql
SQL
1 vote254 views1 answer
Sql sort column by date
SQL