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

What is plan in cobol db2?

589


How do I import a csv file into db2?

558


What is package in cobol db2?

699


What is the use of reorg in db2?

602


What does db2 plan contain?

572






List out the three types of page locks that can be held.

685


What is the syntax for seeing the columns and data types of a table in the db2 database?

576


What is bind package and plan in db2?

591


When the like statement is used?

634


What is an instance database?

598


What is null in db2?

571


How to check last update on table in db2?

626


What is the usage of open cursor command?

599


In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?

579


Explain packages.

658