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 node in db2?

809


Explain the function of data manager.

808


What is the use of value function?

838


Can you tell me how can you find out the # of rows updated after an update statement?

855


What is db2?

917


What is universal database?

827


Which command is used to connect to a database in DB2 ? Give the Syntax.

829


What is the physical storage length of date data type?

981


What is the difference between drop table and delete table?

783


Define db2.

855


What is the syntax for creating a table in the db2 database?

851


When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?

3325


What is a bind card?

879


Why select is not preferred in embedded sql programs?

934


What does db2 plan contain?

754