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,

---

what are the system privileges that are required by a schema owner (user) to create a trigger on a table?

0 Answers  

---

write a query to delete similar records in same table

13 Answers   TCS,

---

How will we see framework of a table?

2 Answers   Accenture,

---

I have a tablle like this: cust acc ----------- a 1 b 2 b 3 c 4 c 5 c 6 I Want below o/p: cust acc --------------- a 1 b 2|3 c 4|5|6 Please any one can you have any ideas share me. I have urgent requirement.

7 Answers   MTS,

---

write a query to delete similar records in different tables with same structure

4 Answers  

---

How to run sql functions in pl/sql?

0 Answers  

---

there is A table and B table in A table there 5 rows and in b table there are 2 rows i am firing query select * from a,b what will be the output?

7 Answers   Cognizant,

---

explain the advantages and disadvantages of stored procedure? : Sql dba

0 Answers  

---

what is the difference between group by and order by in sql? : Sql dba

0 Answers  

---

How do you update a table in sql?

0 Answers  

---

Can we update views in sql?

0 Answers  

---