What are the commands to make a new table, change a table and remove a table in teradata?

0 Answers  

---

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,

---

Explain some differences between mpp and smp?

0 Answers  

---

How to relege locks in fastload and multiload? example?

4 Answers   IBM,

---

How many macros we can create inside a macro

1 Answers   Wipro,

---

---

Is it necessary to add? Quit statement after a bteq query when I am calling it in a unix environment?

0 Answers  

---

can we join volatile table with general table an global temporary table with general table ?

4 Answers   IBM,

---

Explain the types of join supports by teradata?

0 Answers  

---

What is real time and near real time data warehousing?

0 Answers  

---

what happen if a query fail in dispatcher?

1 Answers   Cap Gemini,

---

Hi Friends I have a sql question, We have the source data as below. 101 address1, address2, address3 and the output shoulb like below 101 address1 101 address2 101 address3 Required a SQL query for this output. Please let me know if you have any sql query for this. Thanks in advance. Hari M

6 Answers   JPMorgan Chase,

---

Explain amp in teradata?

0 Answers  

---