i have a table like sales....the field are Prodid Jan(jam month sales)Feb March 1 20 76 50 2 30 94 40 3 40 90 30 4 70 20 30 5 23 40 40 6 85 30 55 7 84 20 65 8 10 93 40 9 57 30 30 10 38 83 40 11 35 39 90 12 83 89 50 Now the Question is i want get the max sales of 12 products from the months.hint:for eg I WANT GET 89 for product12... Can any one help me

8 Answers   Satyam,

---

What is database exceptions in teradata?

0 Answers  

---

What are the commands to make a new table, change a table and remove a table in teradata?

0 Answers  

---

What are differences between teradata and ansi session modes in teradata?

0 Answers  

---

List out all forms of LOCKS that are available in Teradata.

0 Answers  

---

---

What is use of compress in terdata?Explain?

11 Answers  

---

What is multi insert?

0 Answers  

---

what are the default access rights in the teradata?

1 Answers  

---

in teradata level primary in table level allows duplicates why?

1 Answers   TCS,

---

I want to write one query How to get Matched records and unmatched records in table?

4 Answers   TCS,

---

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,

---

Explain amp in teradata?

0 Answers  

---