Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / guest
select empno,ename from emp where deptno in(
select deptno from dept where dept.deptno=emp.deptno)
when inner subquery has an reference to outer query then
this is know as Correlated sub-query.
| Is This Answer Correct ? | 107 Yes | 23 No |
Post New Answer View All Answers
How to select 10 records from a table?
What's the difference between a primary key and a clustered index?
Which normal form is best?
What is sqlite used for?
What is the benefit of foreign key?
Explain normalization and what are the advantages of it?
What is a sql statement?
Why sql query is slow?
Define SQL and state the differences between SQL and other conventional programming Languages?
What is a procedure in pl sql?
What are synonyms in sql?
Can we join two tables without common column?
How do I install sql?
What is bind reference and how can it be created?
What is sql basics?
