WHERE is used to specify the SEARCH ARGUMENT Values in the SQL Query to re

Explain the use of the WHERE clause?

Question Posted / ms.stanley

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

Please Help Members By Posting Answers For Below Questions

What are union and union all?

920

What is cursor in dbms?

1004

What are the different types of base tables?

1025

Is db2 a programming language?

981

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

1090

What is a storage group (stogroup)?

1189

What is dpf in db2?

1047

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

1042

What is a db2 tablespace?

996

How do I add a column in db2?

997

What is reorg and runstats in db2?

1142

My sql statement select avg(salary) from emp yields inaccurate results. Why?

1032

What is the clustering index in the db2 database?

955

What do you mean by between and in? Is between inclusive of specified range values?

1037

How to create db2 table in mainframe?

1100