What is the query to find nth highest salary?
What is the use of cursors?
Answer Posted / tina
select min(sal)
from tablename
where sal in
(select top n-1 sal from tablename order by sal desc)
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
What is blocking transformation?
What is complex mapping?
Whats the difference between informatica powercenter server, repositoryserver and repository?
Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM
what is song in infrmatica...?
Explain transaction control transformation in informatica
How can you generate reports in informatica?
What is union transformation in informatica?
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
What is informatica worklet?
What is informatica etl tool?
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
What do think which one is the better joiner or look up?
Explain the shared cache and re-cache?
How would you join a node to the already existing domain?