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
- 10898 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
In warehouses how many schemas are there?
What is meant by incremental aggregation?
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
How many numbers of sessions can one group in batches?
How can we delete duplicate rows from flat files?
What is mapping debugger?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
What is the surrogate key?
can we override a native sql query within informatica? Where do we do it?
Explain what are the different versions of informatica?
What is aggregator transformation in informatica?
How do you load only null records into target? Explain through mapping flow.
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
