Interested to Buy Any Domain ? << Click Here >> for more details...
i have a table like
empid ename year month sal
1 x 98 jan 500
1 x 98 feb 500
1 x 98 mar 500
1 x 99 jan 600
1 x 99 feb 600
2 y 98 jan 600
2 y 98 feb 600
2 y 98 mar 600
2 y 99 jan 700
2 y 99 jan 700
and so on
i want to find out totsal for every emp on year wise
plz help me
- 4 Answers
- 10660 Views
- Magna Infotech, I also Faced
- E-Mail Answers
Answer Posted / xyz
select empid, year, sum(sal) as Totalsalary
From employees
group by empid, year;
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
Explain direct and indirect flat file loading (source file type) - informatica
Why sorter is an active transformation?
What is Session and Batches?
What is decode in static cache?
What is status code in informatica?
What does command task mean?
Explain sessions and how many types of sessions are there?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
What is an aggregator transformation?
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
in reporting we add some new objects,how we get the count of the newly added objects to the report
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
What are junk dimensions?
What is a repository? And how to add it in an informatica client?
What is a router transformation?
