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.

i have 2 table table one 4 columns respective values a1 7,a2 6,a3 8 ,a4 12 & table two 4 colums respective values a1 7,a2 6,a3 8,a4 15.if table one & table two 3 colums same then 4th column values 1)Qes diff >5 then print 5 * diff value 2)Que diff <5 print 5

3925

---

If i can use sys.check_constraints to display my constraints from my database using sql server 2005, how can i display then if i am using sql server 2000????

3945

---

what is the difference between a web-garden and a web-farm? : Sql dba

1010

---

Explain lock escalation? : Transact sql

1142

---

What are transaction and its controls?

967

---

what is the maximum length of a table name, database name, and fieldname in mysql? : Sql dba

1064

---

what is a foreign key ? : Sql dba

1026

---

How does sql*loader handles newline characters in a record? : aql loader

985

---

What is sql*plus?

1017

---

Does sql*plus also have a pl/sql engine?

1037

---

What is mutating trigger?

969

---

define sql insert statement ? : Sql dba

974

---

How global cursor can be declare with dynamic trigger ?

2146

---

what are local and global variables and their differences? : Sql dba

1009

---

What is sql scripting?

1034

---