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
- 7713 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
During the Display time, how is the sequence generated by Teradata?
Can you connect multiload from ab initio?
Explain teradata utilities. What is multiload, fast load, tpump?
What are the different design perspectives used in teradata?
Describe the set operators in teradata.
If a Node is busy what are the steps you can take to avoid ?
What are the steps involved in the process flow of the sql statement through channel attached system?
What are the things to be considered while creating secondary index?
What are aggregate tables? How do you design them using teradata?
What are the different methods ot loading a dimension table? A fact table etc?
What is the use of stored procedures in teradata?
Can we have two time dimensions in a schema(either star or snow flake)? For ex if we want joining date of employee and if we want today's sales with time whether can we have two time dimensions for accommodating above tasks?
Difference between stored procedure and macro?
What are the updated features of teradata?
What are the functions of a teradata dba?
