in ur table contains the coloumns like deptno,sal empname
then i want output as
deptno subtotalofdept totalsal
10 3700 3700
20 3400 7100



like that



in ur table contains the coloumns like deptno,sal empname then i want output as deptno subtotalofd..

Answer / yuvaevergreen

select csum(sal,deptno) from employee;

Is This Answer Correct ?    4 Yes 0 No

Post New Answer

More Teradata Interview Questions

How do you check the performance of Teradata Query and list down the basic Performance Tuning steps you use?

2 Answers   IBM,


What is meant by a node?

0 Answers  


why should we go Teradata over Oracle,what is the main differences?

4 Answers   TCS,


in ur table contains the coloumns like deptno,sal empname then i want output as deptno subtotalofdept totalsal 10 3700 3700 20 3400 7100 like that

1 Answers   IBM,


Hello all, There is a table with 4 columns in that 3 columns has been already loaded with 5 million records.4th column is empty,Now I have got 5 million records data which has to be loaded into 4th column.How can I load this data fastly in to the 4th column with out using update

5 Answers   CTS, TCS,






Define views in teradata with syntax.

0 Answers  


What is the Maximum number of volatile tables that can be created?

4 Answers   Mphasis,


Explain the term 'primary key' related to relational database management system?

0 Answers  


What is the difference between SI and JI?

2 Answers  


What are the frequently used data types in teradata?

0 Answers  


On which column will you take primary index???

4 Answers  


What is real time and near real time data warehousing?

0 Answers  


Categories