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

select * from (select rownum rn,emp.* from emp) where mod
(rn,2)=1;

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is informatica metadata?

975


how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process

2099


Explain sessions and how many types of sessions are there?

955


What is a sorter transformation?

1037


How do you change a non-reusable transformation to reusable transformation?

942


how we can load rejected record's at run time?(not through bad files)

2314


Make a note of the quantity vaults made in informatica?

942


Explain load alternative records / rows into multiple targets - informatica

1099


Differentiate between router and filter transformation?

952


Briefly define reusable transformation?

1075


What is substr in informatica?

1135


How to delete duplicate row using informatica?

982


How can you generate reports in informatica?

972


How do you remove duplicate records in informatica? And how many ways are there to do it?

1110


What are pre and post-session shell commands?

1236