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
- 7712 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 happen if a query fail in dispatcher?
What are the uses of client software involved in teradata?
How to cast date "2015-03-03-012204-000000" to timestamp
Is PK concept available in Teradata. If it is how can we create Primary Key for a table in TD
Explain the term 'foreign key' related to relational database management system?
can we join volatile table with general table an global temporary table with general table ?
How to find No. of Records present in Each AMP or a Node for a given Table through SQL?
How a Referential integrity is handled in Teradata?
A certain load is being imposed on the table and that too, every hour. The traffic in the morning is relatively low, and that of the night is very high. As per this situation, which is the most advisable utility and how is that utility supposed to be loaded?
Describe primary index in teradata. And what are the available primary index types?
How do you define Teradata?
What are teradata utilities?
Teradata 
