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 understand by data independence? What are its two types?

0 Answers  

---

Is a server a database?

0 Answers  

---

What is a deadlock and mention how it can be resolved?

0 Answers  

---

How to configure events with firewall?

0 Answers  

---

Define data, entity, domain and referential integrity?

0 Answers  

---

---

What are the ways to controlling cursor behavior?

0 Answers  

---

How do I create a database in access 2010?

0 Answers  

---

What is the use of RECORD option in EXP command ?

1 Answers  

---

What is create database?

0 Answers  

---

What is database bloat?

0 Answers  

---

What is meant by a database?

0 Answers  

---

Can we linked SharePoint to a SQL databasebe?

0 Answers   Sans Pareil IT Services,

---