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

What is the advantage of nosql?

730

How do we accept inputs from user during runtime?

728

What is sql analyzer?

759

Can we insert data into materialized view?

708

what are the features and advantages of object-oriented programming? : Sql dba

727

Does sap use sql?

717

What is self-join and what is the requirement of self-join?

840

Can we group by two columns in sql?

727

What is a unique key?

773

Mention what pl/sql package consists of?

721

What are the constraints available in sql?

780

Which table is left in left join?

714

what is the maximum length of a table name, database name, and fieldname in mysql? : Sql dba

850

What is a recursive stored procedure?

802

Does pl/sql support create command?

742