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
- 6718 Views
- Puma, I also Faced
- E-Mail Answers
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
whats the logic to load the lower level of granularity of data to fact table.
what is the size of u r source(like file or table)?
What is meant by pre and post session shell command?
What is rank transform?
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
Explain lookup transformation in informatica
How you prepared reports for OLAP?
What is primary and backup node?
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
Explain the features of connected and unconnected lookup.
What is a rank transform?
What is a transaction control transformation?
Global and Local shortcuts. Advantages.
What is joiner change?
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
