Explain the use of the WHERE clause?

Answer Posted / ms.stanley

WHERE is used to specify the SEARCH ARGUMENT Values in the
SQL Query to retrieve only selected Data from the DB2 Table

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 a system catalog table in db2?

586


What is difference between isnull and coalesce?

618


What is the use of predicate?

584


What is the physical storage length of date data type?

724


What is drop table?

582






How would you find out the total number of rows in a db2 table?

576


What is declare cursor?

610


What is the use of db2?

586


What is the difference between oracle and db2?

583


How to find the maximum value in a column in the db2 database?

607


What is the difference between spufi and qmf?

637


What is alias in db2?

566


File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?

2375


What is host variable?

593


Define predicate?

643