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

Answer Posted / lakshmi reddy

select * from(select emp.*,rownum r from emp) where r=5 or r=10

Is This Answer Correct ?    8 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What do you understand by user class in cognos?

541


what are the filters in framework manager and report studio?

598


What do you mean by Drill down and Drill Up?

578


i was asked what are the caluclations done by you in your report? plz give reply

1718


What is catalog and types of catalogs in cagonos and which is better?

525






Can you define a query subject?

612


What is a Transformer?

659


All ready we have alias tables for modifications why we are using views if anybody this answer plz reply me

1649


What is a Cube?

697


How create measures and dimensions?

614


Can you define query studio?

579


What are the different kinds of panes included in cognos?

597


Can you define a datastore in cognos?

617


What are various types of gateways in cognos?

550


What is the report studio?

610