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,

---

Does sqlite need a server?

0 Answers  

---

write a query filter the null value data following source? name age john 30 smith null null 24 sharp 35 i want output name age john 30 sharp 35

1 Answers   TCS,

---

I am creating an index on Emp table Empno column,if u using this indexed column in ur SELECT stmt. where clause,then how do u know that yr index will be working or nor? Thanks Advance...

3 Answers  

---

What is memory optimized?

0 Answers  

---

Differentiate between sga and pga.

0 Answers  

---

If we update a complex view, is base table will get update ?

2 Answers   Ardee Technologies, HCL,

---

What if we write return in procedure?

0 Answers  

---

What are basic techniques of indexing?

0 Answers  

---

What is the maximum number of triggers,can apply to a single table?

2 Answers  

---

How does postgresql compare to "nosql"?

0 Answers  

---

What are three advantages to using sql?

0 Answers  

---