select * from (select rownum row_num ,tab.* from table

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

Question Posted / d

Answer Posted / d

select *
from (select rownum row_num
,tab.*
from table tab)
where row_num between 100 and 120

Is This Answer Correct ?

7 Yes

2 No

Please Help Members By Posting Answers For Below Questions

How to use distinct and count in sql query? Explain

956

What are the possible values that can be stored in a boolean data field?

944

What does (+) mean in sql joins?

1006

What is the sql case statement?

950

What is pl sql architecture?

919

How can triggers be used for the table auditing?

1008

How many row comparison operators are used while working with a subquery?

972

what is a composite primary key ? : Sql dba

996

Enlist the data types that can be used in pl/sql?

1001

what is a table in a database ? : Sql dba

989

how to include comments in sql statements? : Sql dba

908

Write a sql query to get the third highest salary of an employee from employee_table?

1026

how to present a past time in hours, minutes and seconds? : Sql dba

942

What do you understand by pl/sql cursors?

1012

what is text? : Sql dba

1006