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,

---

Explain the uses of database trigger.

0 Answers  

---

How do you optimize a stored procedure in sql?

0 Answers  

---

What is over () in sql?

0 Answers  

---

What is the difference between jpql and sql?

0 Answers  

---

---

What is indexing in sql and its types?

0 Answers  

---

What are the types of SQL Statement?

3 Answers  

---

counting the no.of characters occurs in a string by using pl/sql function

1 Answers   TCS,

---

What is data control language?

0 Answers  

---

what are the type of locks ? : Sql dba

0 Answers  

---

What is cte sql?

0 Answers  

---

Why do we create stored procedures & functions in pl/sql and how are they different?

0 Answers  

---