SQL Language (MOSC)

MOSC Banner

Deleting Records with Null values

edited Feb 18, 2010 4:04AM in SQL Language (MOSC) 4 commentsAnswered
Greetings -

I have this table that has 120 records total. There are 5 records in COLUMN-A that have Null value (blank). But, when I did count(*) on this table where COLUMN-A is null - I still get 120 records back, I expected to see 115 records because there are 5 records with a null value.

Here is a sample of this basic query:

select count(*) from MYTABLE
WHERE COLUMN-A is null;

Thank you.

A.J.

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