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

What is a standalone command task?

1134


What is lookup transformation?

1001


How to create Target definition for flat files?

1156


Tell me about MD5 functions in informatica

873


What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?

1604


Can we create two repositories on same database instance in oracle?

1014


Reusable transformation and shortcut differences

1779


Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?

1009


Explain pmcmd command usage in informatica

1065


update strategy transformation in informatica

1014


what is the end to end process meaning in my project(my project is development)and functionality plz tell me

1907


Explain about Informatica server process that how it works relates to mapping variables?

1007


What are the different versions of informatica?

1183


Which means the first record should come as last record and last record should come as first record and load into the target file?

1020


Write the prerequisite tasks to achieve the session partition?

1071