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 are 3 types of databases?

0 Answers  

---

What is raid controller technology?

0 Answers  

---

What is rdbms and its features?

0 Answers  

---

What is Dedicated server configuration ?

2 Answers  

---

What is cold backup and hot backup (in case of oracle)?

0 Answers  

---

select Nth highest salary by using rownum

4 Answers   Ford, TCS, Tech Mahindra,

---

Write a query to remove duplicate rows from a table?

0 Answers  

---

Explain what are the types of transparencies?

0 Answers  

---

What are different types of joins in the sql?

0 Answers  

---

What are partitions in database?

0 Answers  

---

what is the use of SYSTEM.EFFECTIVE.DATE varaible ?

1 Answers  

---

What is database example?

0 Answers  

---