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
Is multi insert ansi standard?
What are the main components of teradata system?
In Teradata, how do we Generate Sequence?
In BTEQ, how are the session-mode parameters being set?
Highlight a few of the important components of Teradata?
What are the available primary index types?
What is bteq script in teradata?
What is the difference between fastload and multiload?
What is the use of having index on table?
What is meant by a Least Cost Plan?
What is the meaning of Caching in Teradata?
What is the difference between fastload and multiload? Which one is faster?
What is the use of fallback?
Explain and compare pros and cons of start schemas?
What is a level of granularity of a fact table?