no you have to use IS keyword as: SELECT * FROM CUST WHERE CUSTLOC

Say CUST Table contains records like:
CUSTNO CUSTNAME CUSTLOC
100 ABC SSS
200 XYZ
300 PQR
400 MNO WWW
500 CVV
-------------
-------------
Now write a query to retrieve all records with CUSTLOC no
data.

Question Posted / vineet chauhan

3 Answers
8250 Views
IBM, I also Faced
E-Mail Answers

Answer Posted / vineet chauhan

no you have to use IS keyword as:

SELECT * FROM CUST
WHERE CUSTLOC IS NULL

Is This Answer Correct ?

11 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.

1810

What is the latest version of ibm db2?

1372

If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2

2122