Answer / yuvaevergreen

select csum(sal,deptno) from employee;

i have a table like sales....the field are Prodid Jan(jam month sales)Feb March apr may jun july 1 20 76 50 74 94 93 83 2 30 94 40 94 93 93 02 3 40 90 30 49 94 92 56 4 70 20 30 93 46 35 78 5 23 40 40 39 84 46 57 6 85 30 55 93 46 46 46 7 84 20 65 83 56 57 57 8 10 93 40 93 68 57 36 9 57 30 30 83 67 57 79 10 38 83 40 83 55 68 47 11 35 39 90 94 57 78 47 12 83 89 50 93 79 69 69 i wat ti find the max sales of every product which i want to load into target table

6 Answers   Satyam,

---

What is meant by a Virtual Disk?

0 Answers  

---

what is differences between Fastload and Multiload as per DBA aspect ?

1 Answers   Wipro,

---

in teradata level primary in table level allows duplicates why?

1 Answers   TCS,

---

What do you mean by parsing?

0 Answers  

---

What are the steps involved in the process flow of the sql statement through channel attached system?

0 Answers  

---

Describe primary index in teradata?

0 Answers  

---

I have a employee table with EMPID, EMPNAME, DEPTID, SAL and want to fetch the maximum and minimum salary on each dept id with the emp name. Can anyone help in this? The result should contain the EMPNAME, DEPTID, SAL.

4 Answers   Cap Gemini,

---

How do you design aggregate tables using teradata?

1 Answers  

---

What are the joins in teradata?

0 Answers  

---

How to Skip or Get first and Last Record from Flat File through MultiLoad and TPUMP Utility?

4 Answers   Comsys, IBM,

---

Let us say there is a file that consists of 100 records out of which we need to skip the first and the last 20 records. What will the code snippet?

0 Answers  

---