Explain the use of the WHERE clause?
Answer / 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 |
What is a Foreign Key?
0 Answers Tavant Technologies, Zensar,
In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?
What happens to a cursor after a commit?
suppose in my table 10 rows are there , i want to update odd rows salary as 90000 ? how u do it ? any one help me ? what do we use here cursor-fetch or normal sql ?
How will you delete duplicate records from a table?
What is difference between *omit and *nopass?
Name the various locking levels available?
What is a DB2 bind?
what is check point and restart Logic ? why do we go for that ??
Define db2 and its databases?
What does db2 plan contain?
How would you find out the total number of rows in a db2 table?