Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 3 Answers
- 7605 Views
- Wipro, I also Faced
- E-Mail Answers
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 |
what do you mean by INMOD Routines and OUTMODE Routines ?
How to improve the query performance without taking the collect statistics? In explain plan i have 'NO CONFIDENT'.
If Fast Load Script fails and only the error tables are made available to you, then how will you restart?
Mention the procedure via which, we can run Teradata jobs in a UNIX environment.
Hi frinds pls help me regarding this question WHY usi is two amp operation in teradata? THANKS IN ADVANCE....
what are the day to day activities of teradata DBA ?
What is bteq script in teradata?
which option is used to restart the fastexport script ?
what is use of PI(primary index) AND SI(secondary index)
What is the purpose of joins in teradata?
What are the joins in teradata and how many types of joins are there in teradata?
Describe the between keyword in teradata?
Teradata 
