select * from table_name where rownum between 100 and 120;

A table has 150 records. How do you retrieve 100th row to
120th row from that table ?

Question Posted / mohan

Answer Posted / mohan

Is This Answer Correct ?

2 Yes

2 No

Please Help Members By Posting Answers For Below Questions

what is the difference between sql and t-sql? : Transact sql

1040

How to set up sql*plus output format in oracle?

971

Is time a data type in sql?

851

what is clause? : Sql dba

1001

What is sql stand for?

944

What is an oracle stored procedure?

985

How can we debug in PL/SQL?

1089

What is example of database?

984

Explain the working of foreign key?

975

what is normalization? : Sql dba

1014

Explain the purpose of %type and %rowtype data types?

874

Why are indexes and views important to an organization?

897

Why do we use subquery?

942

Is vs as in pl sql?

932

Is there a way to automate sql execution from the command-line, batch job or shell script?

917