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
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / tdguy
Above answer is correct. Update statement would be the best
option (with case).
Update tablename
set mark3 = case when mark1>mark2
then mark1 else mark2 end;
Is This Answer Correct ? | 3 Yes | 0 No |
Answer / 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 |
How to load specific no.of records using bteq, or fastload,or multiload
How to cast date "2015-03-03-012204-000000" to timestamp
Hi All, can anyone tell me how many types of Skew exists? whats the difference between amp skew,data skew,cpu skew, io skew, delta amp cpu ?
How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .
How to run a query in teradata?
Difference between stored procedure and macro?
Which Teradata concept allows more than one model generation?
What is a sparse index?
What is meant by a Parsing Engine?
Explain Teradata performance tuning and optimization?
How can we pass Variable in Bteq with out using shell script Is it possible or not If possible let me know how can we pass varaibale
suppose one Cylinder split data blocks are moved from where?