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 is different between the data warehouse and data mart?

1114


What is the cumulative sum and moving sum?

1238


What are the data movement modes in informatica?

1211


Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?

1173


whats the logic to load the lower level of granularity of data to fact table.

2314


Define the various join types of joiner transformation?

1045


Name at least 5 different types of transformations used in mapping design and state the use of each.?

1200


Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.

2404


How do you set a varible in incremental aggregation

1951


How to use pmcmd utility command?

1077


What do you understand by SOA of Informatica?

1046


Have you worked with/created Parameter file

1714


Explain the shared cache and re-cache?

1166


What is resilience time?

1227


What is workflow monitor?

1103