Source is Sales Table: Sno Prod Sales Sales_Amount 1 A 10 2000 2 A 20 1000 3 C 10 3000 4 D 30 4000 5 A 20 1000 Target : Sales_Count T_Sales_Amt Sales_Count(A) T_Sales_Amt(A) 90 11000 50 4000 In single query, pls tell me.

5 Answers   CGI,

---

1 SELECT a.field1, b.field2, c.field3, d.field4 2 FROM atable a, atable b, ctable c, dtable d 3 ? 4 ORDER BY 1 What is the minimum number of joins that must be specified on line 3 in the sample code above to properly link the tables? Notice that the table "atable" is aliased twice: once as "a" and once as "b." 1. One join 2. Two joins 3. Three joins 4. Four joins 5. Five joins

6 Answers   Sonata,

---

What is the difference between delete, truncate and drop command?

0 Answers  

---

How to run sql*plus commands in sql developer?

0 Answers  

---

What are the two virtual tables available at the time of database trigger execution?

0 Answers  

---

Name some usages of database trigger?

0 Answers  

---

ex: take one schema in that t1,t2,.....tn tables and you don't no the table name also. write a procedure if enter columns name then display the maching columns .otherwise display the unmatch columns.

1 Answers   Zensar,

---

Is drop table faster than truncate?

0 Answers  

---

What is pl sql in dbms?

0 Answers  

---

What is sharding in sql?

0 Answers  

---

What is data type in database?

0 Answers  

---

Does group by remove duplicates?

0 Answers  

---