Which is more efficient group by or distinct to find duplicates?

0 Answers  

---

where we can use the delimiter in mload? pls let me know

2 Answers   Wipro,

---

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,

---

What are the string manipulation operators and functions associated with teradata?

0 Answers  

---

How do you verify a complicated sql?

0 Answers  

---

What are the 5 phases in a multiload utility?

0 Answers  

---

What do you mean by teradata sql assistant?

0 Answers  

---

How to copy teradata scripts from ur remote desktop to server machine?

3 Answers  

---

What is the use of upsert command in teradata?

1 Answers  

---

what is identity columns in TD?

2 Answers   Wipro,

---

Why MLOAD needs Work Tables?

5 Answers   Teradata,

---

why should we go Teradata over Oracle,what is the main differences?

4 Answers   TCS,

---