Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between IN subselects and EXISTS
subselect?
- 1 Answers
- 10959 Views
- HCL, PreVator, TCS, I also Faced
- E-Mail Answers
Answer / s
IN subselect will return rows that match the values in the
IN list. EXISTS will return rows if the subselect return a
true value.
| Is This Answer Correct ? | 11 Yes | 2 No |
how do you resolve -805?
Update command
Explain the contents that are a part of dclgen.
What are the disadvantages of using VARCHAR?
What is data manager?
What is the difference between SYNONYM and ALIAS?
What is COPY PENDING status?
What is sqlcode -811?
7 Answers Accenture, CTS, TCS,
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.
What is the picture clause of the null indicator variable?
Which catalog tables contain authorization information?
How many clustering indexes can be defined for a table?
COBOL 
