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 are set operators in sql? : Sql dba

1108

What is record variable?

1044

Explain the the delete statements in sql?

1117

What is the command used to fetch first 5 characters of the string?

1467

What is rename in sql?

1019

Does inner join remove duplicates?

1005

what is the use of set statement in tsql? : Transact sql

1063

What is the primary key?

1003

What are the 3 modes of parameter?

1209

What is difference between hql and sql?

1166

What is cold data?

1015

Can you select everything, but 1 or 2 fields, without writer's cramp?

1041

What are the 3 types of behavioral triggers?

1314

What is an alias command?

1119

how does a local variable is defined using t-sql? : Transact sql

1061