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
- 6716 Views
- Puma, I also Faced
- E-Mail Answers
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 are the steps involved in the migration from older version to newer version of Informatica Server?
what is worklet and what use of worklet and in which situation we can use it?
What are the join types in joiner transformation?
How the informatica server sorts the string values in Rank transformation?
i did MBA in 2008. i got job as a Software Engineer(Informatica) in 2008 February in our college campus interviews through consultancy. my problem is when iam going interview HR people ask " YOu are MBA graduate how u get software(informatica) job". iam saying i got job in campus interviews. i have knowledge in informatica in dataware housing. is this answer correct or not. plese give me guidence
how we can add header and footer to flat files?
2 Answers Tech Mahindra, Zensar,
Define error Threshold?
Explain the pipeline partition with real time example?
What are the parts of Informatica Server?
What is lookup change?
How would you copy the content of one repository to another repository?
What could be the possible resons of locks by user?
Teradata 
