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,

---

Describe the set operators in teradata.

0 Answers  

---

What is meant by a Least Cost Plan?

0 Answers  

---

The transaction exceeded the maximum number of rowhash locks allowed

1 Answers   Wipro,

---

1)WHAT IS THE EXACT DIFFERENCE BETWEEN TERADATA AND ORACLE? 2)MOST OF THE COMPANIES ARE USING TARA DATA FOR "DWH PROJECTS" ONLY? WHY?

6 Answers   Bank Of America, Wipro,

---

---

If RDBMS is halted what will you do ?

0 Answers   Teradata,

---

Explain how spool space is used.

0 Answers  

---

What are the things to be considered while creating secondary index?

0 Answers  

---

can i call router is a passive transformation

2 Answers  

---

What is the use of upsert command in teradata?

1 Answers  

---

Explain the parallel data extension in teradata?

0 Answers  

---

If the table does not have duplicates then which utility you can suggest to load the data ?

3 Answers  

---