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 pl sql record in oracle?

1010

What do you mean by “trigger” in sql?

1054

What is trigger and stored procedure in sql?

1016

What is exception? What are the types of exceptions?

1060

What are the benefits of stored procedures?

1046

Explain the components of sql?

1042

What is varchar sql?

1117

How do you copy a table in sql?

1047

what is sp_pkeys? : Transact sql

1138

Is sqlite good enough for production?

981

How to fetch alternate records from a table?

1208

What is recursive join in sql?

984

how can you see all indexes defined for a table? : Sql dba

975

What does where 1/2 mean in sql?

1048

What do you mean by stored procedures? How do we use it?

980