Explain the use of the WHERE clause.
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 buffrpool? Where we use it ?
When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?
How to find the maximum value in a column in the db2 database?
Is schema the same as database?
What is the physical storage length of each of the following DB2 data types: DATE, TIME, TIMESTAMP?
How do I import a csv file into db2?
pls explain the precompilation process of cobol-db2 pgm
How would one remove old reorg information from the DB2 catalog?
how we will do null data selection in cobol-db2 program
What is node in db2?
What is a clustering index ?
What is sqlca’s maximum length?