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

3 votes198 views1 answer
Index using in query plsql
SQL
4 votes186 views3 answers
Order by value mysql
SQL
0 vote183 views2 answers
ON DUPLICATE KEY UPDATE for postgres
SQL
1 vote206 views1 answer
Psql view enum values
SQL
2 votes149 views1 answer
Foreign key example in dbms
SQL
5 votes203 views4 answers
Select random rows sql
SQL
0 vote194 views1 answer
Sql server check whether column has same equal values
SQL
0 vote194 views3 answers
Get free card roblox
SQL
3 votes215 views3 answers
Illuminate database queryexception could not find driver (sql select * from
SQL
5 votes197 views1 answer
Commentaire table oracle
SQL