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

ie.

select column from table_name where mod(primary_key_column,2)=1;


select employee_id from employees where mod(employee_id,2)=1

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What all are steps in up gradation of Informatica server?

1011


What is complex mapping?

1081


Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?

2071


HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION

1864


What is the Process to creating lookup transformation in informatica

1003


What is depict expression change?

1055


How to generate or load values in to the target table based on a column value using informatica etl tool.

1037


What is meant by lookup transformation?

1053


How to do the error handling of if ur source is flatfiles?

1929


How do you load only null records into target? Explain through mapping flow.

1976


can any one give some examples for pre sql and post sql(Except dropping and creating index).

4059


Explain your project of banking domian.

1622


can any one explain about dataflow in the informatica project for bank domain....thanks is advance

10646


What is workflow? What are the components of the workflow manager?

1088


How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?

1989