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
- 9161 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
What are the main features of Oracle 8i with context to datawarehouse?
How to elaborate tracing level?
How to Create a folder using pmrep command?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
where to store informatica rejected data? How to extract the informatica rejected data?
How to handle decimal places while importing a flatfile into informatica?
what is INFORMATICA TESTING process
What is the benefit of session partitioning?
can anyone explain me about retail domain project in informatica?
Define mapplet?
What is the difference between router and filter?
How can you generate reports in informatica?
difference between repository database and repository service?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
