Link to home
Start Free TrialLog in
Avatar of chalie001
chalie001

asked on

check null values

how can i check the null value
i have this select * from employee
where empno = null but returning 0 rows
ASKER CERTIFIED SOLUTION
Avatar of Ryan Chong
Ryan Chong
Flag of Singapore image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
NULL "has no value" so it isn't possible to know if it is equal to any value

you can only know if it IS NULL

i.e. SQL syntax does not allow you to use = and NULL together

no points please
Avatar of chalie001
chalie001

ASKER

Corrects