1. Categories >> Software >> Data Warehouse >> Teradata
  2. Suggest New Category

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

Question Posted / naveen.d121


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 are the different table types supported by teradata?

0 Answers  

What is a node in teradata? Explain

0 Answers  

How do you determine the number of sessions?

0 Answers  

what is use of fload loading into set table?

2 Answers   IBM,

How teradata makes sure that there are no duplicate rows being inserted when its a set table?

0 Answers  




Which is more efficient group by or distinct to find duplicates?

0 Answers  

How do you do backup and recovery in teradata?

0 Answers  

Mention a few of the ETL tools that come under Teradata.

0 Answers  

Difference between inner join and outer join?

0 Answers  

What is meant by a Least Cost Plan?

0 Answers  

I want to load 1000 rcds using. FL for every 100 records there is a check point.But script failed at 120 records, when we are restarting the script, it starts from last ckpt, but Target table contains populated data but FL doesnt support existing data in target table. How can we load data in FL?

4 Answers   IBM,

What are the frequently used data types in teradata?

0 Answers  

For more Teradata Interview Questions Click Here
Categories