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

How does a self join work?

1018

Advantages and disadvantages of stored procedure?

1068

How can you tell the difference between an index and a view?

879

What is the difference between having and a where in sql?

1048

What are sql triggers used for?

972

What is the difference between sql, mysql and sql server?

1033

What is sql deadlock?

1062

What is sqlite used for?

946

How many sectors are in a partition?

1046

How do you optimize a stored procedure in sql?

911

how many triggers are allowed in mysql table? : Sql dba

1016

What is the difference between jpql and sql?

1043

Can we call stored procedure in function?

918

What is the main difference between sql and pl/sql?

1046

What is sql constant?

959