Interested to Buy Any Domain ? << Click Here >> for more details...
How do you Generate sequence at the time of Display?
- 2 Answers
- 8254 Views
- Infosys, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / yuvaevergreen
select csum(1,columnname) will give you the sequence with the mentioned column arranged in ascending order.
| Is This Answer Correct ? | 2 Yes | 1 No |
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
How would you load a very large file in teradata in general?
Which is faster fastload or multiload?
1)WHAT IS THE EXACT DIFFERENCE BETWEEN TERADATA AND ORACLE? 2)MOST OF THE COMPANIES ARE USING TARA DATA FOR "DWH PROJECTS" ONLY? WHY?
6 Answers Bank Of America, Wipro,
What is smp and mpp platforms?
I WANT TO LEARN TERA-DATA ,SO CAN ANY BODY PLZ REFER WHAT ARE THE TOPICS I HAVE TO GO THROUGH, TO GET ASAP JOB ,SO PLZ REFER ME WHERE I CAN GET NICE COACHING ON TERADATA.
which option is used to restart the fast load script?
How to Extract data from multiple legacy systems?
we have two tables emp,dept.emp has eno,ename,sal and dept has deptno,dname.how to find maxsal of each dept wise.which join used for joining.
5 Answers Accenture, Cognizant,
How can we load single row of data into teradata database. please give me the process.
Explain the term 'columns' related to relational database management system?
Write a single SQL to delete duplicate records from the a single table based on a column value. I need only Unique records at the end of the Query.
Teradata 
