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
- 6369 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Describe the between keyword in teradata?
What do you mean by teradata sql assistant?
What are the steps involved after the disk manager passes the request?
What are the components provided on node?
Explain the advantages of partitioned primary index in a query?
Syntax for case when statement?
Mention a few of the ETL tools that come under Teradata.
If Fast Load Script fails and only the error tables are made available to you, then how will you restart?
What do you mean by tpt in teradata?
What are the functions performed by bynet?
Explain the parallel data extension in teradata?
There is a column with date in it. If I want to get just month how it can be done? Can I use sub string?
What is the particular designated level at which a LOCK is liable to be applied in Teradata?
What can be achieved by using the teradata rdbms?
Why is the case expression used in teradata?
