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

How is the teradata different from oracle?

0 Answers

What is basic teradata query language?

0 Answers

What is the Maximum number of volatile tables that can be created?

4 Answers Mphasis,

hi guys...i have good experiance in oracle ...now i want to learn teradata? how much of percentage my knowledge is used to understand the teradata? i mean.. if teradata also having sql queries or not?

1 Answers

What is SQL Assistence?please eample

4 Answers IBM,

what is identity columns in teradata

2 Answers Wipro,

Is it necessary to add? Quit statement after a bteq query when I am calling it in a unix environment?

0 Answers

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

2 Answers Wipro,

If the PMON is not working then how do you manage and monitor all processes, resources and sessions etc.

0 Answers

What are the available primary index types in teradata.

0 Answers

what is single value and Multivalue ?

1 Answers IBM, Wipro,

Describe the between keyword in teradata?

0 Answers

For more Teradata Interview Questions Click Here