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



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 is the multi-insert?

0 Answers  


What is the purpose of using case expression in teradata?

0 Answers  


in a BTEQ we have 2 insert 2 del 2 update statment. when the BTEQ is restarted i need to run the BTEQ from after DEL statment(means no need to run the insert & del stat).what is the logic for the above requirement?

2 Answers   HCL,


How can we pass Variable in Bteq with out using shell script Is it possible or not If possible let me know how can we pass varaibale

1 Answers  


What are the various indexes in teradata? Why are they preferred?

0 Answers  


Frnds.... i have one doubt we have the num like this +913757575......i want to remove 91 and i want lo load remaining data to the target table.. whinch function we can use in teradata????? Plz let me know.. thanks in advance

2 Answers  


What are the components provided on node?

0 Answers  


Explain PDE.

0 Answers  


what are the file sizes in your project?

2 Answers  


Explain fallback in teradata?

0 Answers  


What is Difference b/w PI & PPI?how to implement PPI?

3 Answers   Wipro,


How do you eliminate duplicates?

3 Answers  


Categories