Answer Posted / slokh

FROM clause
A subquery can also be found in the FROM clause. These are
called inline views.

For example:

select suppliers.name, subquery1.total_amt
from suppliers,
(select supplier_id, Sum(orders.amount) as total_amt
from orders
group by supplier_id) subquery1,
where subquery1.supplier_id = suppliers.supplier_id;

In this example, we've created a subquery in the FROM
clause as follows:

(select supplier_id, Sum(orders.amount) as total_amt
from orders
group by supplier_id) subquery1

This subquery has been aliased with the name subquery1.
This will be the name used to reference this subquery or
any of its fields.

Limitations:

Oracle allows an unlimited number of subqueries in the FROM
clause.

What is the primary use of normalization?

1053

---

What is an escape character in sql?

1070

---

Explain commit, rollback and savepoint.

1054

---

why does the selected column have to be in the group by clause or part of an aggregate function? : Sql dba

1161

---

What is a natural join sql?

1038

---

Where is sql database stored?

1037

---

Enlist the characteristics of pl/sql?

1844

---

What is number function in sql?

1016

---

how to increment dates by 1 in mysql? : Sql dba

1030

---

What is cost in sql execution plan?

1042

---

how to install mysql? : Sql dba

1156

---

Difference between truncate, delete and drop commands?

1142

---

How to convert comma separated string to array in pl/sql?

1240

---

Which is better join or subquery?

1187

---

What is trigger explain with example?

1091

---