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

1 Answers
5558 Views
IBM, I also Faced
E-Mail Answers

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 identity column in TD?

2 Answers Wipro,

What is the difference between teradata and basic rdbms?

0 Answers

There is a load to the Table every one hour and 24/7.Morning trafic is high, afternoon trafiic is less, Night trafiic is high.According to this situation which Utility you use and how do you load,which utility used?

4 Answers IBM,

How do you Generate Sequence in Teradata?

3 Answers TCS,

Name the five phases that come under MultiLoad Utility.

0 Answers

Can we collect statistics on multiple columns?

0 Answers

Where we use PPI in real time??? What is the disadvantages of PPI?

3 Answers IBM, Mphasis,

Why FLOAD does not support multiset tables??

3 Answers TCS, Tesco,

What is basic teradata query language?

0 Answers

How you will check the version of teradata?

0 Answers

Aborted in Phase 2 data acquistion completed in fastload?

2 Answers

What are the scenarios in which full table scans occurs?

0 Answers

For more Teradata Interview Questions Click Here