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

select * from (select rownum rn,ename,job,sal
from emp)
where mod(rn,2) <> 0;

Is This Answer Correct ?    2 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

is it possible to index the data in cache of lkp transformation ?

2018


Is it possible to define a single node as a Gateway node as well as worker node?

1105


Describe an informatica powercenter?

1109


Explain joiner transformation in informatica

1110


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

1107


Explain incremental aggregation in informatica

1110


Differentiate between joiner and lookup transformation?

1094


Explain what is informatica metadata and where is it stored?

1035


How to generate sequence numbers using expression transformation?

1075


What are the components of workflow manager?

1075


My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?

6451


What is a passive transformation?

1081


what is index?how it can work in informatica

2029


what are the Methods For Creating Reusable Transformations?

1154


How do you load more than 1 max sal in each department through informatica or write sql query in oracle?

1561