How to display last 5 records in a table ?
With out Top key word and doing order by desc
Advance thanks
Answer Posted / priyank
select * from emp
minus
select * from emp where rownum <= (select max(rownum)-5
from emp)
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What are the measure objects?
How can we delete duplicate rows from flat files?
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
Please let me know how to make encryption and decryption with example?
What is a repository? And how to add it in an informatica client?
What is a predefined event?
How to Create a folder using pmrep command?
4 yrs etl devloper roles and responsibilities?any body give solutions
How do we call shell scripts from informatica?
Explain transaction control transformation in informatica
What is a pre-defined event and user-defined event?
Explain sessions and how many types of sessions are there?
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
What are the advantages of informatica?
Which is the t/r that builts only single cache memory?