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
- 7592 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
Explain the most common data types used in teradata?
What is database exceptions in teradata?
My table got locked during mload due to a failed job. What do I do to perform other operations on it?
While creating table my dba has fallback or no fallback in his ddl. What is that?
Can you connect multiload from ab initio?
What is the purpose of joins in teradata and what are the available join types?
Can we have an unconnected lkp to lookup a db2 record against a teradata record? Doesnt seem to work. I could be wrong
How do you see a ddl for an existing table?
What is stored procedure in teradata?
What is multi insert?
What are the steps to create a data model?
If I wanted to run a TPump job only once per day - basically working on a file that is produced once per day - how would you set up the parameters for that sort of job ?
What is the opening step in basic teradata query script?
How teradata makes sure that there are no duplicate rows being inserted when its a set table?
What is inner join and outer join?
