Link to home
Start Free TrialLog in
Avatar of Saqib Husain
Saqib HusainFlag for Pakistan

asked on

Query Syntax not returning results related to null

I have these queries

select * from institutes_list where gender =null;
select * from institutes_list where gender <> null;

each of them separately returns only one record with all null values

but when I say

select * from institutes_list;

I get many lines where gender is nul and many other lines where gender is either male or female
Avatar of Jim Dettman (EE MVE)
Jim Dettman (EE MVE)
Flag of United States of America image

Link to home
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Saqib Husain


Great, thanks.

I thought I had tried IS.