select * from(select <table_name>.*,rownum rn from <Table

A table has 150 records. How do you retrieve 100th row to
120th row from that table ?

Question Posted / srinivas

Answer Posted / srinivas

select * from(select <table_name>.*,rownum rn from <Table_name>) where rn between 100 and 120

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

column A column b | output 10 7 | 10 5 8 | 8 7 -9 | 7 3 5 | 5 0 6 | 6 Write a sql query to print such output.

7496

what are the differences between char and varchar? : Sql dba

1122

what is a composite primary key ? : Sql dba

1095

Explain the difference between rename and alias?

1068

What are sql indexes?

1048

Can a view be mutating? If yes, then how?

1088

How many sql commands are there?

1159

What is the difference between join and natural join?

984

What is Materialized View? In What Scenario we Use Materialized View?

9622

what is the syntax used for partition in tsql? : Transact sql

1061

what are the authentication modes in sql server? How can it be changed? : Sql dba

1514

What is an alias command?

1119

Is merge a dml statement?

1032

Is sqlite free?

1024

what are the differences between get and post methods in form submitting. Give the case where we can use get and we can use post methods? : Sql dba

1185