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

How to view db2 table structure?

1065

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

1092

What is the result of open cursor statement?

1127

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

1150

What is meant by explain?

1194

Which isolation level provides maximum concurrency?

1203

How to retrieve rows from a db2 table in embedded sql?

1444

How to check sequence on a table in db2?

1116

Explain what are the various isolation levels possible?

1097

What is a Foreign Key?

1139

before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?

2222

What is rebind in db2?

1117

Give the name of some fields form sqlca.

1142

B37 abend during spufi?

1511

Explain how can you do the explain of a dynamic sql statement?

1176