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 do the initials DDL and DML stand for and what is their meaning?
how to resolve -805 . how to see dbrm and package not found
What language is db2 written in?
How is deadlock resolved?
how to u check the query is executing or not ?where will u check for sqlcode ?
What is difference between rollback and commit?
in GDG: is it poosible to copy records from a file which utilizes some 100 cylinders to a gdg whose model is defined as trk(1,0) and also it possible to copy 100 bytes file to 80 bytes file?
How many databases can be created inside an instance in db2 ?
database DSNDB01 means a.db2 catalog b.db2 directory c.BSDS d.active logs answer with reason please
Is db2 free?
How to restart a DB2 program?
On which levels locks can be applied?