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

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

More Teradata Interview Questions

When tpump is used instead of multiload?

What do you mean by fastexport in teradata?

What is meant by a Clique?

What is called partitioned primary index (ppi)?

What are the multiload utility limitations?

What is the diffrence between Multiload & Fastload interms of Performance?

What is smp and mpp platforms?

what is differences between Fastload and Multiload as per DBA aspect ?

How to run a query in teradata?

Explain the term 'tables' related to relational database management system?

Explain the types of join supports by teradata?

Can we have an unconnected lkp to lookup a db2 record against a teradata record? Doesnt seem to work. I could be wrong

For more Teradata Interview Questions Click Here