select * from(select rt.*,rownum r from (select * from gpr

write the sql query to display 5th and 10th row in a table?

Question Posted / gautam ramteke

Answer Posted / gautam ramteke

select *
from(select rt.*,rownum r from (select * from gpr_employee
order by hire_date)rt)
where r in (5,8);

Is This Answer Correct ?

2 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Can you define a datastore in cognos?

612

What are the themes in a data warehouse?

590

What is meant by drill down?

524

Can you explain cognos planning?

671

how to merge 2 crosstabs thans

2163

What are the message flows?

561

what is online view?

1524

Explain the difference between powerplay transformer and power play reports?

604

9. What was the most complex type of report you dealt with?

1737

-----------------What is Direct and Conventional loading?

1650

What is meant by junk dimension?

575

How can you link a query to a data container manually in Report Studio?

1932

how many notations are posible(cordinolity)are there in between two tables(one is fact and another is dimension)pls give me a example pls.

1492

Does anybody have the sample of delivery document of cognos, or provide some link of websites Thanks

1600

What is called materialized view?

597