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,3,5);

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What does “tail –f” command do and what is its use as an Informatica admin.

1029


Can we get 1st record through Informatica(without sequence number).

1406


How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?

1914


How can we store previous session logs?

989


Is it possible to create multiple domains on a single Informatica server?

1180


What is a predefined event?

1032


What are active transformations.

1592


What is a joiner transformation and why it is an active one?

998


How can we remove the duplicates from flat file source?

948


How do you load first and last records into target table?

1099


In informatics server which files are created during the session rums?

1063


Separate from an archive server and a powerhouse?

905


How can you increase the performance in joiner transformation?

1134


Enlist the differences between database and data warehouse.

1033


What is blocking transformation?

1082