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 normalization in a database?

1161

How to write html code in pl sql?

1119

Can variables be used in sql statements?

1036

what is a constraint? Tell me about its various levels. : Sql dba

988

If a cursor is open, how can we find in a pl/sql block?

1167

Why do we use procedures in sql?

1089

how to escape special characters in sql statements? : Sql dba

1038

What is asqueryable?

977

What is a sql profiler?

1030

Why do we need unique key in a table?

960

what does it mean to have quoted_identifier on? : Sql dba

1146

What are user defined functions?

1024

Explain scalar functions in sql?

1072

How do you create an update query?

965

What is sql constant?

1039