I didnt understand ur question,give me correct question and excat o/p u w

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

Question Posted / rajesh

3 Answers
7709 Views
Wipro, I also Faced
E-Mail Answers

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

Please Help Members By Posting Answers For Below Questions

What are the various etl tools in the market?

1121

Can we collect statistics on multiple columns?

1122

What are the various indexes in teradata? Why are they preferred?

1053

What are some commonly used bteq scripts?

1058

Explain vproc in teradata?

1042

What are some primary characteristics of teradata?

1050

How do you do backup and recovery in teradata?

1077

Explain teradata architecture?

1147

Explain teradata utilities?

1093

What is bteq utility in teradata?

1024

What is real time and near real time data warehousing?

1160

What are the different table types that are supported by teradata?

1049

My table got locked during mload due to a failed job. What do I do to perform other operations on it?

1156

What is meant by a dispatcher?

1062

Difference between multiload and tpump?

1157