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

7 votes185 views3 answers
Sql set
SQL
15 votes175 views4 answers
Sql update from select
SQL
0 vote170 views1 answer
Connexion mysql
SQL
0 vote186 views3 answers
Condition in count sql
SQL
7 votes166 views3 answers
Postgre describe table
SQL
0 vote163 views1 answer
Sql value exists in column
SQL
4 votes188 views5 answers
Get last query in codeigniter 4
SQL
0 vote155 views1 answer
Sqlalchemy.exc.DBAPIError: (ibm_db_dbi.Error) ibm_db_dbi::Error: SystemError('<built-in function connect> returned NULL without setting an error')
SQL
1 vote150 views1 answer
Stored procedure return value
SQL
6 votes172 views4 answers
Mysql group by month
SQL