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
Answer Posted / 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 |
Post New Answer View All Answers
What is confirmed fact in dataware housing?
Differentiate between sessions and batches?
What if the source is a flat-file?
Can we override a native sql query within informatica?
What are the main features of Oracle 8i with context to datawarehouse?
Briefly define reusable transformation?
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
How to convert multiple rows to single row (multiple columns) in informatica
What is the difference between stop and abort in informatica
What is a node in Informatica?
How to load last n records of file into target table - informatica
What is expression transformation?
How to create the source and target database connections in server manager?
what is SDLC way of code development?
Which transformation should we use to normalise the COBOL and relational sources?