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
What is scalar function in sql?
Can you skip header records while loading? : aql loader
When are we going to use truncate and delete?
How do I upgrade sql?
How can I get the number of records affected by a stored procedure?
How do I view output in sql developer?
What are the indexing methods?
What are different categories of sql commands?
What is clause in sql?
what is a unique key ? : Sql dba
How do I find duplicates in sql?
Which one is better subquery or joins?
Can we use ddl statements in stored procedure sql server?
What is the basic structure of an sql?
How do you respond to dementia behavior?