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
- 7717 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
What is the purpose of indexes?
What is the use of having index on table?
How can we check the version of Teradata that we are using currently?
Highlight the advantages of PPI(Partition Primary Index).
What type of indexing mechanism do we need to use for a typical data warehouse?
What is the purpose of joins in teradata?
Explain parsing engine in teradata?
What are the frequently used data types in teradata?
What is teradata?
What is the basic syntax for teradata select statement?
What is a clique?
Can we collect statistics on multiple columns?
What exactly do you know about catching in teradata?
What are teradata utilities?
What is called partitioned primary index (ppi) and discuss the advantages of using it in a query?
