Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

What are different table types used in teradata?

1097


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

1788


What is a node in teradata?

1051


What is the use of virtual processor connectivity in teradata?

1096


Differentiate primary key and partition key?

1036


What exactly do you know about catching in teradata?

1082


What do you mean by parsing?

1166


What is teradata? What are some primary characteristics of teradata?

1030


What do you mean by teradata intellicloud?

1079


In a table can we use primary key in one column and in another column both unique and not null constrains.if yes how?

1251


What is oltp?

1018


What is meant by Teradata Gateway?

1115


How to identify ppi columns?

1249


How can bottlenecks be identified?

1067


How to find duplicates in a table?

1277