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 |
Explain db2.
by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?
query to just fetch first matching row and stop execution. once one matching row is found ..no more records should be checked.. if the first record is matching.. the query must stop
Is db2 a programming language?
What is innodb buffer pool?
What is buffer pool and list some of them?
which is the most efficient tablespace?? a.simple tablespace. b.partitioned tablespace. c.segmented tablespace. d.none of the above. please post answer with the reason.?
What is sqlcode -922 ?
What is drop table?
What is a correlated sub query?
How to resolve -917 sql code in DB2?
What is the self-referencing constraint?