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

Answer Posted / yuvaevergreen

Is This Answer Correct ?

4 Yes

0 No

Please Help Members By Posting Answers For Below Questions

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

1018

how many modules are there in telecome domain?how to explain the architecture?

2016

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

1050

What is TPD?

1374

Give a justifiable reason why Multi-load supports NUSI instead of USI.

1154

Can any one explain me the difference between BTEQ and MLOAD,TUMP. All canbe used for same purpose but still differnt methods. why ?

3625

What are the steps to create a data model?

1054

If RDBMS is halted what will you do ?

2169

Explain teradata utilities?

1042

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

1080

Explain the advantages of partitioned primary index in a query?

1028

What are the functions of a teradata dba?

1078

Highlight the differences between Primary Key and Primary Index.

1091

What are some commonly used bteq scripts?

1012

What are teradata utilities?

1111