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
- 6347 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 how spool space is used.
Name the five phases that come under MultiLoad Utility.
i learn teradata,it is so intersting,now i want teradata certifications ,so any 1 help me to get teradata certifications TD 12 ? email:kdcrazyy@gmail.com
Write a program to show the parser component used in teradata?
Explain teradata utilities. What is multiload, fast load, tpump?
Why teradata is used?
tomorrow i have interview in infosys.can someone pour any suggestions or any interview questions. thank you
In general, how do you optimze any sql in teradata?
What are the newly developed features of Teradata?
What are the updated features of teradata?
What are the different methods ot loading a dimension table? A fact table etc?
What are the different functions included in the server software?
Hi Friends, Please send me Teradata Materials for certifications Thanks in advance !!
Can you fastexport a field, which is primary key by putting equality on that key?
what are the day to day activities of teradata DBA ?
