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
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
How to do unit testing in informatica? How to load data in informatica ?
Differentiate between joiner and lookup transformation?
Can we create a node as a gateway node and the same node can be assigned to a grid?
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
Enlist the various types of transformations.
What does refresh system mean, and what are its distinctive choice?
How you can differentiate between connected lookup and unconnected lookup?
How are indexes created after completing the load process?
Whats the difference between informatica powercenter server, repositoryserver and repository?
What's the layout of parameter file (what does a parameter file contain?)?
What is workflow? What are the components of workflow manager?
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.
Explain the different kinds of facts.
What are the differences between source qualifier and joiner transformation?
Informatica Checkpoints