what is the difference between the query and corelated
query
- 8 Answers
- 19121 Views
- HSBC, IBM, TCS, Xenosoft, I also Faced
- E-Mail Answers
Answer Posted / chintu
A query is nothing but if we want to evaluate one thing we
will write query. like
select * from emp; --->> query
A Query is evaluated once for each and every row from the
parent statement is called corellated Query.
like
select * from emp outer where sal= ( select avg(sal) from
emp e where dept.e=dept.outer) --> corelated query
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is cursor explain with example?
How much does sql certification cost?
What is sp_helptext?
How do you modify a trigger?
What are the qualities of 2nf?
What is a join query?
What is rollback?
What does t sql mean?
Explain aggregate functions are available there in sql?
How is a process of pl/sql compiled?
How do I clear the screen in sql plus?
Why are sql stored procedures used?
Is ms sql traffic encrypted?
How consistent is the view of the data between and within multiple sessions, transactions or statements ?
Can you load data into multiple tables at once? : aql loader
