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

Where not exists in sql?

983

Does sql*plus also have a pl/sql engine?

1082

Define join and name different types of joins?

1008

What are the types of operators available in sql?

1067

What is identity column in sql server?

1054

What are sql indexes?

1004

what is the difference between mysql_fetch_array and mysql_fetch_object? : Sql dba

1072

What are types of indexes in sql?

1084

Why indexing is needed?

992

What are the advantages of indexing?

986

Under what condition it is possible to have a page level lock and row lock at the same time for a query? : Transact sql

992

What does joining a thread mean?

1023

what are myisam tables? : Sql dba

1033

what is the difference between myisam static and myisam dynamic? : Sql dba

1067

What are character functions in sql?

943