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
- 11029 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
Which are the different editions of informatica powercenter that are available?
What is option by which we can run all the sessions in a batch simultaneously?
What is the use of target designer?
what is size of u r database?
What are the tasks that can be performed using sq?
Where is metadata stored?
What are the popular informatica products?
Define Pmrep command?
Partition, what happens if the specified key range is shorter and longer
In warehouses how many schemas are there?
What are the types of schemas we have in data warehouse.
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
What is enterprise data warehousing?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
Explain how to import oracle sequence into informatica?
