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
Answer / gd
select empid,monthyear from empsal where sal>100000;
Is This Answer Correct ? | 11 Yes | 2 No |
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 |
Answer / sateesh
select * from empsal GROUPBY ‘monthyear’
HAVING sal>=100000.
Is This Answer Correct ? | 0 Yes | 4 No |
Answer / animesh
Select EMPID from EMPSAl
Group By monthyear
where
sal> 100000
Is This Answer Correct ? | 2 Yes | 8 No |
what is metadata?
How to extract sap data using informatica? What is abap? What are idocs?
What is the benefit of session partitioning?
What is a code page in Informatica
3 Answers American Express, Cognizant, Deloitte,
Can we create multiple integration service on single repository?
What are the types of caches in lookup?
What are the reusable transforamtions?
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?
How we can confirm all mappings in the repository simultaneously?
Define pmcmd command?
How can we integrate different flat file data in a single mapping and with in a single execution
Can we get 1st record through Informatica(without sequence number).