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 are different table types used in teradata?

While creating table my dba has fallback or no fallback in his ddl. What is that?

how do you manage the production space. what are the proactive methods you can take ?

How to Extract data from multiple legacy systems?

1)WHAT IS THE EXACT DIFFERENCE BETWEEN TERADATA AND ORACLE? 2)MOST OF THE COMPANIES ARE USING TARA DATA FOR "DWH PROJECTS" ONLY? WHY?

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

plz explain parlla distribution and subtable concept in teradata

How to identify ppi columns?

Explain teradata utilities. What is multiload, fast load, tpump?

where we can use the delimiter in mload? pls let me know

What are the uses of client software involved in teradata?

what is DYNAMIC SQL in TD?

For more Teradata Interview Questions Click Here