Answer / sudipta santra

Inline query :
select * from emp where empno=(select max(empno) from emp);

Co-Related sub query:

Select * from emp where dob> (select distinct dob where
deptno= 10);

Note: In the Inline subquery , The main query depends upon
the outcome value of the inline sub query which is in-lined
but in case of co-related sub query the main query and sub
query both run simultaneously then the check occurs.

What do you mean by aggregate and scalar functions in dbms?

0 Answers  

---

What is network database?

0 Answers  

---

What is difference between database and server?

0 Answers  

---

Mention the differences between union and union all

0 Answers  

---

Can a DIALOG WINDOW have scroll bar attached to it ?

1 Answers  

---

Define atomicity and aggregation.

0 Answers  

---

What is the example of rdbms?

0 Answers  

---

What is use of dbms?

0 Answers  

---

what are the advantages of using them.

0 Answers  

---

Enlist some commands of dml?

0 Answers  

---

How do I create a database in access 2010?

0 Answers  

---

What is the purpose of sql?

0 Answers  

---