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
- 7549 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 bteq utility in teradata?
What does sleep function does in fast load?
What are teradata utilities?
how many modules are there in telecome domain?how to explain the architecture?
What is the difference between teradata and basic rdbms?
What are the primary characteristics of the Teradata.
What is TPD?
What do you mean by ttu in teradata?
What is the function of parser component in teradata?
How is MLOAD Teradata Server restarted after execution?
How would you load a very large file in teradata in general?
Explain vproc in teradata?
Why is the case expression used in teradata?
What are the uses of client software involved in teradata?
Can any one explain me the difference between BTEQ and MLOAD,TUMP. All canbe used for same purpose but still differnt methods. why ?
