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.

Is sql open source?

953

---

How do I send sql query results to excel?

1048

---

How many indexes can be created on a table in sql?

1035

---

Explain the purpose of %type and %rowtype data types?

905

---

what are the authentication modes in sql server? : Sql dba

1043

---

What's the procedure?

915

---

What jobs use sql?

966

---

Why sql query is slow?

974

---

what is the difference between primary key and unique key? : Sql dba

1015

---

What are the types of subqueries?

1047

---

Why is sql important?

1088

---

Which is better join or inner query?

1018

---

how are mysql timestamps seen to a user? : Sql dba

1117

---

what happens if null values are involved in expressions? : Sql dba

1028

---

Which join is like inner join?

1005

---