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 full join in sql?

982

---

What is the difference between microsoft access and sql server?

1046

---

What is restrict in sql?

1098

---

How many types of cursors are available in pl/sql?

1098

---

how many ways to get the current time? : Sql dba

1001

---

How can you get sql*loader to commit only at the end of the load file? : aql loader

1003

---

How is indexing done in search engines?

979

---

What is number function in sql?

957

---

Is sql easier than java?

1002

---

What are tuples in sql?

1122

---

What is a trigger word?

1014

---

Why stored procedures are faster than query?

1019

---

Can we insert in sql function?

1073

---

Explain the difference between 'between' & 'and' operators in sql

991

---

What can I use instead of union in sql?

957

---