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 the design features involved in teradata?
What's the difference between timestamp (0) and timestamp (6)?
Can we have two time dimensions in a schema(either star or snow flake)? For ex if we want joining date of employee and if we want today's sales with time whether can we have two time dimensions for accommodating above tasks?
Explain teradata utilities. What is multiload, fast load, tpump?
What is the basic syntax for teradata select statement?
How to run a query in teradata?
What do you mean by teradata intellicloud?
Difference between inner join and outer join?
Highlight a few of the advantages that ETL tools have over Teradata.
How is MLOAD Teradata Server restarted after execution?
Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com
how do you manage the production space. what are the proactive methods you can take ?
What is spool space and when running a job if it reaches the maximum spool space how you solve the problem?
Different phases of multiload?
What are the different table types that are supported by teradata?