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 / sp hari

select * from emp where rowid=(select
decode(mod(rownum,2),0,null,rowid) from emp)

Is This Answer Correct ?    4 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Briefly explain the aggregator transformation?

993


I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.

1161


Could you explain what is enterprise data warehouse?

1136


Write the program through which the records can be updated?

998


How do we call shell scripts from informatica?

1107


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

1024


How many types of sessions are there in informatica.please explain them?

1161


Explain Dataware house architecture .how data flow from intial to end?

2577


What is the fact table?

1060


what is the size ur source like(file system or database)? how many record daily come u r banking project?

2141


how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?

2450


Briefly define reusable transformation?

1125


How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.

1773


How can we use batches?

1024


What is rank index in rank transformation?

1075