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

What is audit logout in sql profiler?

1005

Explain cursor types?

1001

Can we use the cursor's to create the collection in PL/SQL?

1003

What is the main difference between sql and pl/sql?

1070

What is rownum and rowid?

1018

What is a loop in sql?

969

what are numeric data types? : Sql dba

1046

Why do we use procedures in pl sql?

1007

What is pl sql and why it is used for?

1098

Explain what is a view?

1041

What is the difference between unique and primary key constraints?

1047

What is data type in sql?

941

Can we use insert statement in function?

980

How is indexing done in search engines?

971

Why do we use cursors?

975