Explain the use of the WHERE clause.

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do you eliminate duplicate values in db2?

688


What is dbrm? When it will be created?

602


What db2 400?

680


What is explain in db2?

585


What is a bind in db2?

594






How do you simulate the explain of an embedded sql statement in spufi/qmf?

637


How do I add a column in db2?

596


What is the use of reorg in db2?

610


Following a db2 update statement, what is the quickest way to compute the total number of updated rows?

627


When do you specify the isolation level?

612


What is ibm db2 used for?

601


What is catalog database in db2?

646


What does db2 mean?

589


What is an instance in db2?

567


What is package in cobol db2?

704