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

Is left join inner or outer by default?

1005

What are inbuilt functions in sql?

1027

Can we use insert statement in function?

982

What is cascade in sql?

945

what are different types of keys in sql?

1127

How many types of tables are there?

932

How do I view tables in mysql?

955

what is 'mysqldump'? : Sql dba

1092

What is a column in a table?

1106

What can you do with pl sql?

1078

Is and as keyword in pl sql?

942

How do I pipe the output of one isql to another?

989

What are local and global Indexes and where they are useful.

1431

What is sql partition function?

1183

how to decrement dates by 1 in mysql? : Sql dba

1007