Explain the use of the WHERE clause.
- 2 Answers
- 4429 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 |
Mention a credible reason why select* is never given preference in an sql program that has been embedded.
How do you eliminate duplicate values in db2?
how will you retrieve first record in table
what is cursor stability?
Hi , I am posting some interview ques . what is the use of cursors ? what is the diff between select and cursor ? bith are used for data retrival .. rite?
if one db2 pgm calls another db2 pgm. how many plans do we need. what r the steps involved..
ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE
Why do we use cursor?
What does db2 blu stand for?
If the main program has only cobol statements and subprogram has the db2 statements what is the procedure for precompilation. for which program we need to do the precompilation
What is a precompiler?
How many sub queries can you combine together ?
COBOL 
