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.

Explain the components of rdbms?

0 Answers  

---

How is data stored in a relational database?

0 Answers  

---

When should you consider denormalization?

0 Answers  

---

What do you mean by cardinality and its types?

0 Answers  

---

Mention some disadvantages of query?

0 Answers  

---

What is 2nf in database?

0 Answers  

---

What is " group by " clause?

0 Answers  

---

Why dbms is used?

0 Answers  

---

Explain about cursors?

0 Answers  

---

What are different types of joins in sql?

0 Answers  

---

What is data modelling techniques?

0 Answers  

---

What is difference between database and dbms?

0 Answers  

---