Explain the use of the WHERE clause.
- 2 Answers
- 4185 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / tharanath.n
you can restrict the rows returned from query by using the
where clause,a where clause contain a condition that must
be met, and it directly follows the from clause. if the
condition is true, the row meeting the condition is returned
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / s
The WHERE clause only retrieves the rows based on the
predicate coded in the SQL.
| Is This Answer Correct ? | 0 Yes | 0 No |
What is QUIESCE?
what is the use of bind parameter, Replace?
If we have 100 records in the PF, we deleted all the records then what is the Size of the PF?
What is the use of db2?
What's The Error Code For Unique Index Voilation?
What is a cursor?
the dd name for ksds is dest1 and what is the dd name for alternate index of ksds ? a.dest b.dest1 c.dest1a d.dd1
can any one expalin check point with an example?
What is ibm db2 client?
Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?
Is it possible to precompile if db2 goes down?
how to resolve -805 . how to see dbrm and package not found
COBOL 
