Interested to Buy Any Domain ? << Click Here >> for more details...
i have oracle table A and target B. i don't know how many
records. i want get get last record in table A as first record
in target table B. write a sql query?
- 7 Answers
- 10566 Views
- IBM, TCS, I also Faced
- E-Mail Answers
Answer Posted / upendra
select * from (select rownum as num,a.* from A a) where num=(select count(*) from A);
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What do you mean incremental aggregation?
Is there any way to read the ms excel datas directly into informatica?
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
What is event and what are the tasks related to it?
What is incremental aggregation?
Could you explain what is enterprise data warehouse?
How to create a non-reusable instance of reusable transformations?
How can you define user defied event?
What is enterprise data warehousing?
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
Explain how to import oracle sequence into informatica?
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
What is decode in informatica?
What is workflow monitor?
