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 / punyaslok

(select * from emp)-(select rownum,emp.* from emp order by
mod(rownum,2);

Is This Answer Correct ?    0 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Briefly describe lookup transformation?

1051


How can informatica be used for an organization?

1225


What is target load order?

1254


Can we create a Integration service without a Repository service and vice versa?

1221


What are the modules in Power Center

1688


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

1176


Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.

1302


what are the fact table & dimensional table in pharmaceutical and hospotal related products???

2140


Explain the mapping variable usage example in informatica

1168


How to join three sources using joiner? Explain though mapping flow.

1155


Why sorter is an active transformation?

1203


What are the types of lookup transformation?

1086


What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?

979


What is mapplet in informatica?

1067


What is a connected transformation?

1133