Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

how will u get 1 and 3rd and 5th records in table what is
the query in oracle please help me

Answer Posted / kondeti srinivas

select * from emp where (rowid,1) in (select rowid,mod(rownum,2) from emp where rownum<=5)

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

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.

1652


how we can load rejected record's at run time?(not through bad files)

2327


What are data-driven sessions?

1155


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

1718


What is informatica worklet?

1001


in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records

2201


Explain sessions. Explain how batches are used to combine executions?

965


What is domain in terms of informatica?

969


How can you increase the performance in joiner transformation?

1152


Explain the features of connected and unconnected lookup.

889


How to extract sap data using informatica? What is abap? What are idocs?

1115


i have a data in my source as a flat files what test i have to perform the next step can any body help to me

2081


Define update strategy?

1133


what is diff b/t sorter t/r and agg have the option sorter property...

2143


Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?

965