Answer Posted / asnani_satish@yahoo.com

Minor correction in above answer
Difference between sub-query, correlated query and query as
table
1. Sub-query : the inner query is executed in entirety
before the outer query is executed
eg select * from emp where deptno in (select deptno from dept);

2. Correlated Query: For each record fetched in outer query
corresponding matching records are fetched in sub-query
because of join condition within inner sub-query. Answers
1,2,3 are correct

3. Query as Table: A query can behave as a table

select a.empno,a.sal,a.sal/b.avgsal*100 as percent_avg_sal
from emp a,(select deptno,avg(sal) avgsal from emp group by
deptno) b
where a.deptno=b.deptno;

Here the entire "(select deptno,avg(sal).....)" behaves as
table named "b" containing dept wise average sal. The query
is behaving as a temporary table.

how to create a test table in your mysql server? : Sql dba

1057

---

how to convert character strings to numeric values? : Sql dba

1168

---

Explain the difference between 'between' & 'and' operators in sql

1046

---

what is table? : Sql dba

1109

---

Why do we need a foreign key?

1168

---

How to fetch values from testtable1 that are not in testtable2 without using not keyword?

1285

---

How does cross join work?

1008

---

Can a foreign key be null?

1144

---

Is sql similar to python?

1042

---

What is difference between db2 and sql?

1046

---

What does trigger mean in slang?

1126

---

What is pivot in sql?

973

---

What is the benefit of foreign key?

1070

---

Is t sql a programming language?

1114

---

Is a foreign key always unique?

984

---