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 votes148 views1 answer
What is having
SQL
0 vote117 views1 answer
Postgres : ERROR: division by zero
SQL
0 vote84 views2 answers
Https://www.google.com/search?ei=bihqX_v9DJb--gTYoLH4DQ
SQL
0 vote114 views2 answers
Clear window pl sql
SQL
20 votes127 views1 answer
Sql change column types
SQL
5 votes120 views2 answers
Sql create tabel with primary key auto_increment code
SQL
0 vote167 views1 answer
Do you know sql
SQL
-1 vote126 views1 answer
Sql set max value in column
SQL
0 vote118 views1 answer
Select in select sql
SQL
0 vote116 views1 answer
Postgres data location
SQL