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

What is inner join and outer join?

0 Answers  


Why teradata is used?

0 Answers  


Explain some differences between mpp and smp?

0 Answers  


I have a employee table with EMPID, EMPNAME, DEPTID, SAL and want to fetch the maximum and minimum salary on each dept id with the emp name. Can anyone help in this? The result should contain the EMPNAME, DEPTID, SAL.

4 Answers   Cap Gemini,


what is referential constraints?how do you implement RI in teradata?

2 Answers   Wipro,






A Query was run fine earlier. It is not running properly now. what are proactive steps you can take as a dba ?

1 Answers  


Fast Load Script is failed and error tables are available then how do you restart?

3 Answers   TCS,


What can be achieved by using the teradata rdbms?

0 Answers  


Can any one please provide me practical example of How to do the performance tuning in Query??

5 Answers   Amdocs,


What is the use of fallback?

0 Answers  


If table have access lock.In the same table write lock is posible or not?

1 Answers  


What tools would you use for that?

0 Answers  


Categories