select csum(sal,deptno) from employee;

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 / yuvaevergreen

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

Answer Posted / yuvaevergreen

select csum(sal,deptno) from employee;

Is This Answer Correct ?

4 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Explain how spool space is used.

1020

What do you mean by parsing?

1060

Highlight the need for Performance Tuning.

1030

What is the purpose of using case expression in teradata?

958

Hi Friends, Please send me Teradata Materials for certifications Thanks in advance !!

2095

Differentiate primary key and partition key?

937

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

1036

What are the various indexes in teradata? How to use them?

956

Highlight a few of the advantages that ETL tools have over Teradata.

1034

What is upsert statement in teradata?

1052

Syntax for case when statement?

1010

What are the multiload utility limitations?

1006

i learn teradata,it is so intersting,now i want teradata certifications ,so any 1 help me to get teradata certifications TD 12 ? email:kdcrazyy@gmail.com

2150

What are the various indexes in teradata? Why are they preferred?

959

Can we collect statistics on multiple columns?

988