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,

---

How many types of index are present in teradata?

1 Answers  

---

why use references rather than pointers in the public api, particularly for arguments which are modified?

0 Answers  

---

What tools would you use for that?

0 Answers  

---

What is oltp?

0 Answers  

---

Describe primary index in teradata. And what are the available primary index types?

0 Answers  

---

Find 2 highest sal from each dept who have completed 5 year in org

0 Answers   Wipro,

---

Can some one tell me the ressolution for the error. I was not able to answer this question in wipro interview. "The transaction exceeded the maximum number of rowhash locks allowed"

1 Answers   Wipro,

---

What is meant by MATCHTAG in multiload utility?

2 Answers   Satyam,

---

What is the difference between global temporary tables and volatile temporary tables?

0 Answers  

---

any one pls tell me what are the table names in banking project?

2 Answers  

---

Why teradata is used?

0 Answers  

---