Interested to Buy Any Domain ? << Click Here >> for more details...
Scenario is like this:
Name Sal
A 10;
B 20;
C 30;
Then Output should be
Name Sal
A 10;
B 20;
C 30;
Total 60;
Use SQL For this scenario
- 4 Answers
- 7679 Views
- TCS, Wipro, I also Faced
- E-Mail Answers
Answer Posted / pooja
Select case when GROUPING(e.Name)= 1
then'Total'else e.Name end as Name,
sum(e.Salary)as Salary from Emp e
group by e.Name with rollup
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the fact table?
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
What is a passive transformation?
complex mapping ur project u r invlve can u explain and give real time example give me ?
What is the use of code page?
What do you mean by channel change?
What are the components of workflow manager?
How to convert multiple rows to single row (multiple columns) in informatica
Mention some types of transformation?
What are roles and groups and benefits of using them?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
What do you mean by worklet?
What is mapplet in informatica?
Explain what are the different versions of informatica?
