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
- 7584 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 are the various reporting tools in the market?
What is meant by a Channel Driver?
What is collect statistics?
What type of indexing mechanism do we need to use for a typical data warehouse?
What is basic teradata query language?
In BTEQ, how are the session-mode parameters being set?
What is meant by a Virtual Disk?
Highlight a few of the advantages that ETL tools have over Teradata.
What is the difference between teradata and oracle?
What is the meaning of Caching in Teradata?
Backup Script was blocked you are unable to archive the data now. how do you analyze it and where do you identify ?
hi frnds i want to learn teradata utilities and teradata dba real time. i have 1+ years of experience in teradata. so i want to go deeply in Tearada. plz let me know at my email id who r best to learn from. im lookng for a realtime guy in HYD or Banglr. Thanks in advance. Rajesh my email-id: rajeshmss87@gmail.com
Explain fallback in teradata?
Mention a few of the ETL tools that come under Teradata.
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
