Hi All, I have a table with 3 fields like id,mark1,mark2 and I would like to update a mark3 field that would calculate the max for each record (so the max value of the 2 fields) in Teradata ID Mark1 Mark2 Mark3 1 10 20 2 20 30 3 40 10 4 50 50 I Have to write a update statement Mark3 with max value of mark1,mark2 fields…like bellow ID Mark1 Mark2 Mark3 1 10 20 20 2 20 30 30 3 40 10 40 4 50 50 50 Please any one help me ....Thq

3 Answers   Wipro,

---

Why Multiload does not supports USI and supports NUSI?

4 Answers  

---

What is smp and mpp platforms?

0 Answers  

---

Explain teradata architecture in detail with a diagram.

0 Answers  

---

What is a three-tier data warehouse?

0 Answers  

---

what do you mean by INMOD Routines and OUTMODE Routines ?

3 Answers  

---

Why Fload doesn’t support multiset table?

9 Answers  

---

What's the syntax of sub string?

1 Answers  

---

How to eliminate product joins in a teradata sql query?

0 Answers  

---

I have all the TERADATA Certification Dumps for the below: NR0-011, NR0-012, NR0-013, NR0-014 NR0-015 NR0-016, NR0-017 If anyone need it, pls drop me a mail with Code in the mail to: terashish@gmail.com

201 Answers   Cognizant, Deloitte, IBM, Prometric, Syntel,

---

How a Referential integrity is handled in Teradata?

5 Answers  

---

How do you Generate Sequence in Teradata?

3 Answers   TCS,

---