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
9114 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

On which transformations you created partitions in your project?

1355

What is the procedure for creating independent data marts from informatica 7.1?

1068

is it possible to index the data in cache of lkp transformation ?

2033

What do you mean by enterprise data warehousing?

1071

Name the different lookup cache(s)?

1240

Explain the different dimensions.

974

What is the surrogate key?

1273

How to join three sources using joiner?

1124

What is the need of etl tools?

1124

Tell me about MD5 functions in informatica

932

Define the various join types of joiner transformation?

991

Briefly define reusable transformation?

1137

What does “tail –f” command do and what is its use as an Informatica admin.

1115

What is a dimensional model?

991

what is size of u r database?

2316