Select EMPID from EMPSAl Group By monthyear where sal> 100000

following scenario empsal table i want who exist one lakshs
sal above monthwise?
`
empsal

empid monthyear sal
1 jan2008 1000
2 march2009 50000
3 april2009 4000
4 feb2009 100000
5 jul2009 600000
6 dec 2008 90000

Question Posted / animesh

5 Answers
8877 Views
Wipro, I also Faced
E-Mail Answers

Answer Posted / animesh

Select EMPID from EMPSAl
Group By monthyear
where
sal> 100000

Is This Answer Correct ?

2 Yes

8 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Differentiate between router and filter transformation?

958

Tell me any other tools for scheduling purpose other than workflow manager pmcmd?

1274

What is a joiner transformation?

940

What is the difference between informatica 7.0 and 8.0?

956

Which transformation should we use to normalise the COBOL and relational sources?

1143

What is a difference between complete, stop and abort?

1035

What are the uses of etl tools?

1071

lookup transformation with screenshots

3943

What is the benefit of session partitioning?

1051

What is the Rank index port in Rank transformation?

1015

What does refresh system mean, and what are its distinctive choice?

1077

What is Cognos script editor?

4168

Can u generate reports in Informatica?

1028

What is mapplet in informatica?

986

What is incremental aggregation?

1019