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
Answer Posted / yuvaevergreen
select csum(sal,deptno) from employee;
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What are different table types used in teradata?
how do we write scripts in unix how to execute scripts in real time anybody please needfull or give me number i will cal u
What is a node in teradata?
What is the use of virtual processor connectivity in teradata?
Differentiate primary key and partition key?
What exactly do you know about catching in teradata?
What do you mean by parsing?
What is teradata? What are some primary characteristics of teradata?
What do you mean by teradata intellicloud?
In a table can we use primary key in one column and in another column both unique and not null constrains.if yes how?
What is oltp?
What is meant by Teradata Gateway?
How to identify ppi columns?
How can bottlenecks be identified?
How to find duplicates in a table?