What is inner join and outer join?
No Answer is Posted For this Question
Be the First to Post Answer
How to find No. of Records present in Each AMP or a Node for a given Table through SQL?
What is the purpose of joins in teradata?
What is Join Index in TD and How it works?
How will you solve the problem that occurs during update?
What exactly do you know about catching in teradata?
Highlight the limitations of TPUMP Utility.
Can we take collect stats on Dervied Tables and Volitable tables, What is Golabal Temporary table what is the use of this Golabal Temporary table ,When we create any kind table in Teradata it will show in Golabal Temporary table
Explain the most common data types used in teradata?
What do high confidence, low confidence and no confidence mean in explain plan?
How is the teradata different from oracle?
What is the difference between union and union all in teradata?
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