We help IT Professionals succeed at work.

Query Syntax not returning results related to null

16 Views
Last Modified: 2020-04-19
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
Comment
Watch Question

President / Owner
CERTIFIED EXPERT
Fellow
Most Valuable Expert 2017
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
Saqib HusainEngineer
CERTIFIED EXPERT

Author

Commented:
Great, thanks.

I thought I had tried IS.
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.