Could anyone clearly explain the diference between sub
query and correlated sub query?
- 3 Answers
- 4840 Views
- I also Faced
- E-Mail Answers
Answer Posted / praveen
if we want to select 100th hig no.
in sub-query we will write 100 conditions.
to avoid this we go for correlated sub-query
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the difference between dbm cfg and db cfg file in db2 ?
What is package in db2 mainframe?
How do I add a column to a table in db2?
What is access path in db2?
Is it possible using max on a char column?
What is the advantage in De-normalizing tables in DB2?
What is buffer pool?
What does reorg do in db2?
What parameters are used to control the free space in DB2?
What is the physical storage length of time data type?
What is the difference between bind and rebind in db2?
How do you pull up a query which was previously saved in qmf?
What is bind in db2?
In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?
can all users have the privilage to use the sql statement select * (dml)?
