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
- 6821 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 is workflow monitor?
Explain what transformation and how many are there in informatica?
What is fact table? Explain the different kinds of facts.
What is the difference between a connected look up and unconnected lookup?
what is the size of your data warehousing?
what is the complex transformation you used in informatica
Enlist some properties of sessions.
How might one distinguish in the case of mapping is right or not without associating session?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
how many types of dimensions are available in informatica?
What is exclusive and normal mode for repository services?
What is rank index in rank transformation?
What is workflow? What are the components of the workflow manager?
Slowly changing dimensions, types and where will you use them
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
