What is correlated subquery?
Answer / s
Correlated subquery refers to atleast one column of the
outer query. The correlated subquery is evaluated for each
qualifying row from the outer query.
| Is This Answer Correct ? | 1 Yes | 0 No |
What is dbrm?
What is a NULL value? What are the pros and cons of using NULLS?
Under what circumstances will DB2 allow an SQL statement to update more than one primary key value at a time?
What is cursor?
Explain the function done by data manager?
What is a clustering index ?
List down the data types in the db2 database.
What is difference between isnull and coalesce?
What is db2 command?
What is the COBOL picture clause of the following DB2 data types: DATE, TIME, TIMESTAMP?
How many databases are there?
in my table i will update only 100 record among 1000 records i need to display recently updated record'.....can u tell me where those records are stored how can i display those records...?if there is any sql query pls let me know....?