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 are the diffrences between joiner transformation and source qualifier transformation?
After a load is done to my target table, I need to insert a last row, which might be formed at some expression transformation and brought to target. Do I have to have separate mapping to be run after the 1st mapping? Or in a single mapping how to achieve this?
My sql query is 1. select 1+x from dual? 2. select 1+'x' from Dual? 3. Select x+1 from dual? what is the out put of the above queries?
Source as 1 1 2 2 3 3 How to get target as 1 2 3 and 1 2 3
How to create a mapping ? id date 101 2/4/2008 101 4/4/2008 102 6/4/2008 102 4/4/2008 103 4/4/2008 104 8/4/2008 O/P - shud have only one id with the min(date) How to create a mapping for this
what is sql override?what is the use of it?
What is Cognos script editor?
How to enter same record twice in the target table,explain?
How many input parameters can exist in an unconnected lookup?
How did you handle performance issues If you have data coming in from multiple sources, just walk thru the process of loading it into the target
tell me about your project functionality
Hi experts, can anyone tell how much we use plsql in real time