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

4 votes214 views1 answer
To date oracle with time
SQL
1 vote260 views1 answer
Nullif postgresql
SQL
0 vote246 views1 answer
Time data type in mysql
SQL
2 votes231 views2 answers
How to DROP a table in mysql
SQL
0 vote270 views1 answer
Oracle executing sqlplus commands and waiting for completion
SQL
0 vote239 views1 answer
Sql get date from timestamp
SQL
0 vote222 views1 answer
Minecraft duping allowed servers
SQL
0 vote236 views1 answer
Delete a record from a table sqlite3
SQL
0 vote239 views1 answer
Get sum sqlite android
SQL
0 vote232 views1 answer
How to select only the first rows for each unique value of a sql tablecolumn?
SQL