what is the difference between the query and corelated
query
- 8 Answers
- 19107 Views
- HSBC, IBM, TCS, Xenosoft, I also Faced
- E-Mail Answers
Answer Posted / manish
select * from emp; --->> query
select * from emp where sal=(select max(sal) from emp);
--> here a sub query is also there
select * from emp outer where sal= ( select avg(sal) from
emp e where dept.e=dept.outer) --> corelated query
| Is This Answer Correct ? | 9 Yes | 7 No |
Post New Answer View All Answers
What does pl sql developer do?
Is sql a case sensitive language?
what is data integrity? : Sql dba
What are the advantages of pl sql over sql?
Can you have more than one trigger on a table?
What are the 3 types of behavioral triggers?
What is a scalar value in sql?
What is sql query limit?
what is bdb (berkeleydb)? : Sql dba
what is the syntax used for partition in tsql? : Transact sql
Why partition by is used in sql?
Can we call a function containing dml statements in a select query?
How to fix oracle error ora-00942: table or view does not exist
What version is sql?
What are the types of subqueries?
