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 options in the target session of update strategy transsformatioin?
What is incremental aggregation and how it is done?
8 Answers JPMorgan Chase, TCS,
What is the difference between the system variables $$$SessStartTime and SESSSTARTTIME?
A TABLE CONTAINS SOME NULL VALUES . HOW TO GET (NOT APPLICABLE(NA)) IN PLACE OF THAT NULL VALUE IN TARGET .?
what is mapping parameter?
What is CDC? How to implement CDC?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
Briefly describe lookup transformation?
how will compare two mappings in two different repository?
My source table look like ID Name Location Salary 0000001 ran tpty 1000 0000002 ram DELHI 2000 hju-hji raj hyd 1000 my target table should be ID Name Location Salary 1 ran tpty 1000 2 ram DELHI 2000 hju-hji raj hyd 1000
What is the function of aggregator transformation?
How can we use mapping variables in informatica? Where do we use them?