Null DB2

raags · New User Joined: 19 Sep 2005 Posts: 1

Hi Freinds,

Emptab

name char(10) not null
id Char(10) not null
Sal char(10)

In this table, i want to select only those rows where sal should not be null.In this some of the rows have null values in the Sal column. I want to retrive only those rows where Sal is not equal to NULL.

for null we can have where sal is NULL, then what about vice-versa for this?

Regards,
Raags

nitin4.a · New User Joined: 16 Aug 2005 Posts: 26

hi
null is like a condition for noops
so i think you can use this condition with if /else for vice versa i.e use else instead of if for sal not null
regards
sonu

vikramyadav · New User Joined: 28 May 2005 Posts: 41 Location: Gurgaon

hi,
if you want to get the null value records in the salary column then just use the following query:------

select * from <table-name>
where salary is null;