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

How to convert multiple rows to single row (multiple columns) in informatica

1362


Differentiate between Load Manager and DTM?

2137


In what scenario we use to improve session performance by pushdown optimization?can any one give example?

6138


Write the unconnected lookup syntax and how to return more than one column.

1096


How to load the data from people soft hrm to people soft erm using informatica?

991


Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?

1057


Explain how to import oracle sequence into informatica?

986


What are the components of the workflow manager?

1116


Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab

2136


How can a transformation be made reusable?

1138


Explain the shared cache and re-cache?

1092


What is the fact table?

1048


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?

1473


Why sorter is an active transformation?

1167


what is the complex transformation you used in informatica

2575