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
- 7466 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is real time and near real time data warehousing?
What are the uses of client software involved in teradata?
How many tables can you join in v2r5?
Highlight a few of the advantages that ETL tools have over Teradata.
What are tpump utility limitations?
Explain the term 'row' related to relational database management system?
What is smp and mpp platforms?
Syntax for case when statement?
Highlight the need for Performance Tuning.
What are the primary characteristics of the Teradata.
Mention a few of the ETL tools that come under Teradata.
How does hashing happens in teradata?
What is meant by a Least Cost Plan?
What is the purpose of upsert command?
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?
