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
Answer Posted / rajesh
I didnt understand ur question,give me correct question and
excat o/p u wanted ,send example o/p what u wanted
Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What are the string manipulation operators and functions associated with teradata?
Highlight the need for Performance Tuning.
What are the different functions included in the server software?
What are the multiload utility limitations?
Why are oltp database designs not generally a good idea for a data warehouse?
Describe primary index in teradata?
What are the main components of teradata system?
Let us say there is a file that consists of 100 records out of which we need to skip the first and the last 20 records. What will the code snippet?
What are aggregate tables? How do you design them using teradata?
What is the primary index in teradata?
Explain the term 'database' related to relational database management system?
What can be achieved by using the teradata rdbms?
Explain fastload in teradata?
how can we analyze the locks ?
Can you connect multiload from ab initio?