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



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 are the various indexes in teradata? How to use them?

0 Answers  


What is meant by Teradata Gateway?

0 Answers  


Difference between Qualify and group

4 Answers   CTS,


How to handle nulls in Teradata??? How many columns can be there in a table??? How to find average sal with out using avg function????

3 Answers   Mphasis,


What is the particular designated level at which a LOCK is liable to be applied in Teradata?

0 Answers  






What are the commands to make a new table, change a table and remove a table in teradata?

0 Answers  


Hi Friends I have a sql question, We have the source data as below. 101 address1, address2, address3 and the output shoulb like below 101 address1 101 address2 101 address3 Required a SQL query for this output. Please let me know if you have any sql query for this. Thanks in advance. Hari M

6 Answers   JPMorgan Chase,


What is meant by a Highest Cost Plan?

0 Answers  


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

3 Answers   TCS,


how do you handle ET and UV errors ?

2 Answers  


If table have access lock.In the same table write lock is posible or not?

1 Answers  


What are the available join types in teradata?

0 Answers  


Categories