Database Administration (MOSC)

MOSC Banner

Check null for a column in all records in SQL

Hello

How to check for column all records are empty or null, is there any simple way to do it in SQL, like joins or grouping.

Name address phone

a addr1 phone1

b addr2 null

b addr3 null

c addr4 null

a addr5 phone2


If I want to check if all phone for b are null, what will be the easiest way.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center