Interested to Buy Any Domain ? << Click Here >> for more details...
Explain the use of the WHERE clause.
- 2 Answers
- 5551 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 commit in db2?
Is it mandatory to use DCLGEN? If not, why would you use it at all?
What is collection in db2 bind?
Name some fields from SQLCA.
What are the prerogatives?
Do we have any optinon to search part of integer in DB2 as we have for character Like,SUBSTR optins?
Generally if I want to select the names starting with c I need to use c% But how could I code to select the data which contains % as a part of data.
What is lock escalation in db2?
What is the syntax for creating a table in the db2 database?
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?
How do you find the maximum value in a column in db2?
What is a bind card?
COBOL 
