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

Answers were Sorted based on User's Feedback



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

Answer / gd

select empid,monthyear from empsal where sal>100000;

Is This Answer Correct ?    11 Yes 2 No

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

Answer / arpan

Select empid,monthyear,sal from empsal
where sal>100000
orderby monthyear;

Is This Answer Correct ?    2 Yes 0 No

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

Answer / sweta kedia

Select EMPID from EMPSAL Where MONTHYEAR IN(SELECT monthyear
from empsal
Group By monthyear
where
sal> 100000)

Is This Answer Correct ?    1 Yes 1 No

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

Answer / sateesh

select * from empsal GROUPBY ‘monthyear’
HAVING sal>=100000.

Is This Answer Correct ?    0 Yes 4 No

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

Answer / animesh

Select EMPID from EMPSAl
Group By monthyear
where
sal> 100000

Is This Answer Correct ?    2 Yes 8 No

Post New Answer

More Informatica Interview Questions

what is metadata?

6 Answers  


How to extract sap data using informatica? What is abap? What are idocs?

0 Answers  


What is the benefit of session partitioning?

0 Answers  


What is a code page in Informatica

3 Answers   American Express, Cognizant, Deloitte,


Can we create multiple integration service on single repository?

0 Answers  






What are the types of caches in lookup?

0 Answers  


What are the reusable transforamtions?

1 Answers  


I have a scenario which load the data frm single source to 2 targets as T1, T2, and T1 have a P.K and T2 have F.K relations. first data has to load in T2, and then data load to T1 if that record exist in T1... how can we acheive it?

2 Answers   Ness Technologies,


How we can confirm all mappings in the repository simultaneously?

1 Answers  


Define pmcmd command?

0 Answers  


How can we integrate different flat file data in a single mapping and with in a single execution

1 Answers  


Can we get 1st record through Informatica(without sequence number).

0 Answers  


Categories