how do u get the first record from 50,000 records ?

Answer Posted / hanumantharao

select *from emp where rownum=1;

Is This Answer Correct ?    1 Yes 10 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

According to his methodology what all you need before you build a datawarehouse

1191


Why do you use Mapping Parameter and mapping variable?

1288


Parameter and variable differences

1618


what are the deliverables?in your project?

1661


How can you generate reports in informatica?

581






What are the conditions needed to improve the performance of informatica aggregator transformation?

585


How do you promote a non-reusable transformation to reusable transformation?

663


Explain the different lookup methods used in informatica?

589


What is the use of code page?

610


Make a note of the quantity vaults made in informatica?

561


can we override a native sql query within informatica? How do we do it?

654


design of staging area?

1591


What is the function of union transformation?

619


What is a pre-defined event and user-defined event?

579


What is meant by target load plan?

559