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,

---

While creating table my dba has fallback or no fallback in his ddl. What is that?

0 Answers  

---

How do you determine the number of sessions?

0 Answers  

---

What are the various reporting tools in the market?

0 Answers  

---

how teradata fetches a row from primary index table?

1 Answers  

---

---

Differentiate primary key and partition key?

0 Answers  

---

What is Join Index in TD and How it works?

6 Answers   BT, CSC, TCS,

---

Is PK concept available in Teradata. If it is how can we create Primary Key for a table in TD

6 Answers   Wipro,

---

why varchar takes 2 extra bytes?

4 Answers   IBM,

---

hi frnds i want to learn teradata utilities and teradata dba real time. i have 1+ years of experience in teradata. so i want to go deeply in Tearada. plz let me know at my email id who r best to learn from. im lookng for a realtime guy in HYD or Banglr. Thanks in advance. yedu my email-id: jakkayedukondalu@gmail.com@gmail.com

0 Answers  

---

tomorrow i have interview in infosys.can someone pour any suggestions or any interview questions. thank you

0 Answers  

---

The transaction exceeded the maximum number of rowhash locks allowed

1 Answers   Wipro,

---