Answer Posted / pooja intwala
A subquery is a SELECT statement within another SQL statement. The SQL statement can be SELECT, WHERE clause, FROM clause, JOIN, INSERT, UPDATE, DELETE, SET, DO, or another subquery.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How is the value function used?
List down the types of triggers in the db2 database?
What is isolation level in db2?
Explain about cursor stability?
How would you find out the total number of rows in a db2 table?
What is db2 bind?
List out the three types of page locks that can be held.
What is bind and rebind in db2?
What is the difference between cursor stability and repeatable read isolation levels?
ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE
What is buffer pool in the db2 database?
What are the uses of db2 optimizer?
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?
What parameters are used to control the free space in DB2?
How can the firstname and the lastname from the emp table be concatenated to generate complete names?