Answer Posted / ankur akash

A query inside a query is a sub query.
The first query depends for its execution based on the
result provided by the execution of inside query. i.e. subquery.
For ex.
Select last_name, salary, job_id
from employees
where salary >(select last_name, salary
from employees
where last_name = 'Higgins');

Here
Select last_name, salary, job_id
from employees
where salary >
talks about the first query depending for its result based
on the execution of the inner query i.e. sub query
(select last_name, salary
from employees
where last_name = 'Higgins');

What is scope and visibility in PL/SQL?

1204

---

explain the difference between delete , truncate and drop commands? : Sql dba

1093

---

How can you load multi line records? : aql loader

1076

---

Why truncate is faster than delete?

1111

---

What is Materialized View? In What Scenario we Use Materialized View?

9515

---

Which is better stored procedure or query?

957

---

How to create your own reports in sql developer?

1019

---

How many sql are there?

996

---

How do I create an index in word?

1032

---

Is left join faster than inner join?

1123

---

How to handle bulk data?

1310

---

column A column b | output 10 7 | 10 5 8 | 8 7 -9 | 7 3 5 | 5 0 6 | 6 Write a sql query to print such output.

7348

---

Is microsoft sql free?

1101

---

1) Synonyms 2) Co-related Subquery 3) Different Jobs in Plsql 4) Explain Plan 5) Wrap 6) Query Optimization Technique 7) Bulk Collect 8) Types of index 9) IF primary key is created then the index created ? 10) Foreign Key 11) Exception Handling 12) Difference Between Delete and Trunc 13) Procedure Overloading 14) Grant Revoke 15) Procedure Argument types. 16) Functions. 17) Joins

1596

---

Why function is used in sql?

944

---