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 nosql example?

1038

Explian rowid, rownum? What are the psoducolumns we have?

1005

What is a primary key? Explain

976

Differentiate pl/sql and sql?

1071

Why coalesce is used in sql?

1014

How does postgresql compare to "nosql"?

1035

What is data modelling in sql?

1024

What is multiple columns?

1071

What is scalar and vector?

1005

Explain what is a field in a database and record in a database?

1097

Define commit?

1009

What is lookup table in sql?

1053

Can we join two tables without common column?

1010

How to fetch alternate records from a table?

1245

How to convert comma separated string to array in pl/sql?

1188