what is the difference between the query and corelated
query
- 8 Answers
- 18540 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
give the syntax of grant and revoke commands? : Sql dba
How many types of cursors are available in pl/sql?
Is left join and outer join same?
What are tables and fields?
How do I restart sql?
What is error ora-12154: tns:could not resolve the connect identifier specified?
what is the difference between nested subquery and correlated subquery?
What are the topics in pl sql?
How to rename a column in the output of sql query?
How many sql are there?
What is example of database?
How do I install microsoft sql?
Can we use joins in subquery?
What is meaning of <> in sql?
How do I enable sql encryption?
