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.

Can we commit in trigger?

978

---

what are the limitations of identity column? : Transact sql

1108

---

Can a primary key be a foreign key?

1022

---

Mention what plvcmt and plvrb does in pl/sql?

1143

---

How do I view a view in sql?

951

---

What is sql mysql pl sql oracle?

1072

---

What is the use of stored procedures?

1053

---

Why do we use triggers?

967

---

Define sql delete statement.

1016

---

Enlist the advantages of sql.

1001

---

What are different functions in sql?

947

---

What are the constraints available in sql?

1049

---

Can a view be mutating? If yes, then how?

1028

---

What is sql injection owasp?

1066

---

Is sqlite thread safe?

1053

---