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 / kondeti srinivas

Select * from (select rownum as rn, emp.* from emp) where
rn in (1,3,5);

Is This Answer Correct ?    22 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

my source is junk data how will u remove that junk data by using unix please any one replay me

3706


What are the different lookup cache(s)?

1124


How does the aggregator transformation handle null values?

1152


Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM

4167


In informatica workflow manager, how many repositories can be created?

1368


Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?

1095


How to create the source and target database connections in server manager?

1095


What is status code in informatica?

1024


Define joiner transformation?

1056


Explain target update override in informatica

1131


What is a rank transform?

1092


What is Cognos script editor?

4240


What is domain in terms of informatica?

1010


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

1249


Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

1037