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
Can we write dml inside a function in sql server?
What are the different ways to optimize a sql query?
What is rank function in sql?
What schema means?
How do sql triggers work?
Can I call a procedure inside a function?
what is cursor. write example of it. What are the attributes of cursor.
What is trigger and stored procedure in sql?
what is log shipping? : Sql dba
What is the difference between a database and a relational database?
Does varchar need length?
Is sql dba a good career? : SQL DBA
What are the two types of exceptions in pl/sql?
What is the purpose of my sql?
What is a constraint?
