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 / amedela chandra sekhar

Select * from (select rownum as rno, emp.* from emp) where
rno in (1,2,5);

Is This Answer Correct ?    6 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Suppose we do not group by on any ports of the aggregator what will be the output?

982


Tell me about MD5 functions in informatica

874


Under what conditions selecting sorted input in aggregator will still not boost session performance?

1022


What is a code page?

1115


If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?

1429


What are the different components of powercenter?

986


How many numbers of sessions can one group in batches?

1013


How to load data in informatica ?

953


What are the features of complex mapping?

1096


What is a connected transformation?

1047


permutations of mapplet

2454


Explain the types of transformations?

1005


What you know about transaction control transformation?

935


How we can create indexes after completing the loan process?

1142


What is aggregator transformation in informatica?

896