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

Explain the pipeline partition with real time example?

649


Explain in detail about scd type 1 through mapping.

582


Differentiate between a database and data warehouse?

650


What is the benefit of session partitioning?

589


Enlist some properties of sessions.

620






How to handle decimal places while importing a flatfile into informatica?

714


Can we create a Integration service without a Repository service and vice versa?

720


Briefly define a session task?

587


can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project

2133


which one is better performance wise joiner or look up

620


What is a sorter transformation?

653


Tell me any other tools for scheduling purpose other than workflow manager pmcmd?

720


What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?

7668


Define sessions in informatica etl?

612


What is Cognos script editor?

3782