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
5639 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

If I wanted to run a TPump job only once per day - basically working on a file that is produced once per day - how would you set up the parameters for that sort of job ?

0 Answers

How many codd's rules are satisfied by teradata database?

0 Answers

Can we collect statistics on table level?

0 Answers

Can any one plz provide the teradata interview questions?

10 Answers

How can we build data marts from FSLDM. is there any standard approach for this?Is FSLDM supports place ?

2 Answers

what is sysdba and sysdbc ? which has high priority ?

0 Answers Wipro,

What is the difference between SI and JI?

2 Answers

What is logical data model?

0 Answers

What is partitioned primary index (ppi)?

0 Answers

How can we check the version of Teradata that we are using currently?

0 Answers

What do you mean by parsing?

0 Answers

Fast Load Script is failed and error tables are available then how do you restart?

3 Answers TCS,

For more Teradata Interview Questions Click Here