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 vote247 views1 answer
Msg 241, level 16, state 1, line 1 conversion failed when converting date and/or time from character string.
SQL
1 vote315 views1 answer
Sql server cast date dd/mm/yyyy
SQL
1 vote288 views1 answer
Scaffold mysql database
SQL
10 votes318 views1 answer
Oracle dba_dependencies
SQL
0 vote307 views1 answer
Alter owner in PostgreSQL
SQL
0 vote317 views1 answer
How to get specific salary in sql
SQL
0 vote286 views1 answer
Recursive query herarchical data sql server
SQL
0 vote296 views3 answers
Get free card roblox
SQL
1 vote282 views1 answer
Autocommit mysql
SQL
1 vote289 views1 answer
Primary key reset in SQL database
SQL