what is the difference between the query and corelated
query
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
How do sql triggers work?
What is a composite primary key?
What is difference between function and trigger?
Explain dml and ddl?
how is myisam table stored? : Sql dba
Why left join is used in sql?
What is procedure and function in sql?
What is triggering circuit?
Describe sql comments?
What makes a good primary key?
What port does sql server use?
Is progress software supports to ( pl/sql )?
Explain what is sql*plus?
Why indexing is needed?
Does truncate need commit?