Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between the query and corelated
query
- 8 Answers
- 20962 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
How to return an array from java to pl/sql?
Can we enter data in a table in design view?
Why coalesce is used in sql?
What is a Mapplet?
Explain the difference in execution of triggers and stored procedures?
how many groups of data types? : Sql dba
What is scalar function in sql?
What is package in pl sql with an examples?
can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible? : Sql dba
Why do we use set serveroutput on?
how to convert character strings to numeric values? : Sql dba
How do I remove sql plus from windows 10?
What are functions in sql?
How do we use distinct statement? What is its use?
what are the join types in tsql? : Transact sql
