• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

query with the value as null

 
Steve Jiang
Ranch Hand
Posts: 127
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I get 1000 row with with

select * from table1

but less row with
select * from table1 where scheduling =2; 400 row
and
select * from table1 where scheduling !=2; 200 row.

I checked the DB, there is data (400 row ) schduling as null. how can get the result for scheduling as null?

Thanks a lot
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 34396
346
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
David,


I'm moving this to JDBC as it is not Oracle specific.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic