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
7411 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

Describe the between keyword in teradata?

979

What are the functions involved in shared information architecture?

1016

What are the different design perspectives used in teradata?

926

How to find duplicates in a table?

1134

What are teradata utilities?

1032

What is the meaning of Caching in Teradata?

1080

Explain how spool space is used.

1018

What is a clique?

1011

What is real time and near real time data warehousing?

1063

What is the difference between fastload and multiload? Which one is faster?

1144

Define views in teradata with syntax.

1022

what are the uses of fact table and dimension table in banking project?

4491

Explain the advantages of partitioned primary index in a query?

973

Backup Script was blocked you are unable to archive the data now. how do you analyze it and where do you identify ?

1997

Can you connect multiload from ab initio?

1135