Hi NBK, You can use the below UPD query to update the mark3 field with

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 / subbu

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

Answer Posted / subbu

Hi NBK,

You can use the below UPD query to update the mark3 field
with maximum marks of Mark1 or Mark2 fields.

Update db_name.Tab_name
set mark3 = case
when mark1>mark2
then mark1
else mark2
end

Is This Answer Correct ?

13 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Where is teradata rdbms used?

1035

What is meant by a Least Cost Plan?

1002

Differentiate database data and data warehouse data?

1053

What happens when a node suffers a downfall?

1057

Explain the term 'database' related to relational database management system?

929

Define views in teradata with general syntax.

982

What are the uses of client software involved in teradata?

927

What is bteq script in teradata?

1076

What are the advantages of teradata?

956

Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com

2361

What is spool space?

1074

Mention a few of the ETL tools that come under Teradata.

1014

What do high confidence, low confidence and no confidence mean in explain plan?

980

Explain the advantages of partitioned primary index in a query?

973

Explain vproc in teradata?

938