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

What is the process to restart the multiload if it fails?

Why are oltp database designs not generally a good idea for a data warehouse?

What are some primary characteristics of teradata?

what do you mean by INMOD Routines and OUTMODE Routines ?

Explain the most common data types used in teradata?

What are differences between teradata and ansi session modes in teradata?

What is the use of teradata system software?

In the Primary Index, what is the score of AMPs that are actively involved?

Can we load a Multi set table using MLOAD?

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

Define views in teradata with general syntax.

what are the default access rights in the teradata?

For more Teradata Interview Questions Click Here