Manning's Countdown to 2014
. Use discount code crdotd14 all month for 50% off every deal.
A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
query with the value as null
Joined: May 17, 2004
Jul 31, 2004 14:16:00
I get 1000 row with with
select * from table1
but less row with
select * from table1 where scheduling =2; 400 row
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
Joined: May 26, 2003
Jul 31, 2004 15:15:00
select * from table1 where scheduling is null;
I'm moving this to
as it is not Oracle specific.
How To Ask Questions The Smart Way
Blogging on Certs:
SCEA Part 1
Part 2 & 3
Core Spring 3
TOGAF part 1
Did you see how Paul
cut 87% off of his electric heat bill with 82 watts of micro heaters
subject: query with the value as null
Some questions on "select for Update"
Diplaying top five employee names taking highest salary
Dynamic SQL Query Doubt
Preparing a PreparedStatement
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2013