How to display last 5 records in a table ?
With out Top key word and doing order by desc
Advance thanks
Answers were Sorted based on User's Feedback
Answer / madhu
this is can acheieve by following query
select * from(select rowunum r,e.*from emp e) where
r>(select count(*)-5 from emp);
| Is This Answer Correct ? | 4 Yes | 1 No |
Answer / priyank
select * from emp
minus
select * from emp where rownum <= (select max(rownum)-5
from emp)
| Is This Answer Correct ? | 1 Yes | 0 No |
What is the main data object present inbetween source and target. I answered Mapping. Transformation etc.. But it is not the answer. So please give me an apt answer. Thanks in advance
how the data will be loaded while desiging the schema?which one first (for e.g.-dimesions and facts)
How can we use mapping variables in informatica? Where do we use them?
What is a data modeling?
How you prepared reports for OLAP?
What are different types of transformations available in informatica?
A Flat file located in unix source folder. data transfer every day 8 am. can ask 5 question for above scenario validation. recently i have faced this question.
What is status code?
How to go to the older version for a mapping?
What are the types of lookup?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
What are the new features of informatica 9.x developer?