Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 3 Answers
- 7895 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / madhuri tungal
In the CUSTLOC field the no data is represented by SPACES
but not by .... i.e NULL VALUE
Hence the query would be,
SELECT * FROM CUST WHERE CUSTLOC IS SPACES;
| Is This Answer Correct ? | 0 Yes | 3 No |
Post New Answer View All Answers
What are the full forms of spufi and dclgen and why are they used?
How to check last update on table in db2?
My sql statement select avg(salary) from emp yields inaccurate results. Why?
In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?
What is the use of commit in db2?
Explain how can you do the explain of a dynamic sql statement?
What are host variables in db2?
What is commit in db2?
List some fields from sqlca?
What is an instance in db2?
Highlight all the advantages that are attached to a package.
What is db2 command?
can we view the access paths created by dbrm ? how ? thx
What happens in bind step in a db2 program?
Explain about rct.
