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 you update a sql procedure?
What is difference between inner join and cross join?
What is the difference between rename and alias?
What is a scalar value in sql?
Why do we create views in sql?
What is AUTH_ID and AUTH_USER in pl/sql ?
What is execution plan in sql?
How does left join work in sql?
What is sql and how does it work?
What is a mutating table and a constraining table?
Is sql developer case sensitive?
What are the different parts of a package?
What is server name sql?
what are integrity rules?
How do I debug a stored procedure?