In a table, 4 person having same salary. How to get Third
person record only?
Answer Posted / sanju
select * from (select salary.*,rownum r from salary where
sal=(select sal from salary group by sal having count(sal)
=4)) where r=3
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
In which transformation you cannot drag ports into it?
What is mapping debugger?
What is a pre-defined event and user-defined event?
Target increases every day even though no new record was inserted
What is Cognos script editor?
can anyone suggest best free Talend data integration training online
Differentiate between joiner and lookup transformation?
How can you generate reports in informatica?
Define joiner transformation?
what is the size of your data warehousing?
EXL informatica Questions
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
Repository user profiles
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
How do you load unique records into one target table and duplicate records into a different target table?