Interested to Buy Any Domain ? << Click Here >> for more details...
How to display last 5 records in a table ?
With out Top key word and doing order by desc
Advance thanks
- 2 Answers
- 6944 Views
- Puma, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What are the guidelines to be followed while using union transformation?
How to delete duplicate row using informatica?
How to join three sources using joiner?
What is parallel processing in informatica?
How an expression transformation differs from aggregator transformation?
What are the different clients of powercenter?
How to Create a folder using pmrep command?
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?
What are the types of schemas we have in data warehouse.
How to load the data from people soft hrm to people soft erm using informatica?
How to open an older version of an object in the workspace?
What is olap (on-line analytical processing?
What is a stored procedure transformation?
What is a shortcut and copy in Informatica and how two are different with each other?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
