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 primary key secondary key alternate key candidate key?

982

What is clustered index in sql?

1003

How do you bind variables in pl sql?

1036

What are the two types of exceptions.

1108

What is the difference between having and a where in sql?

1033

Is it possible to link two groups inside a cross products after the cross products group has been created?

955

how to use like conditions? : Sql dba

1040

What is a natural join sql?

922

What problem one might face while writing log information to a data-base table in pl/sql?

1067

What is a sql schema used for?

1031

Is t sql a programming language?

1006

What is scalar and vector?

939

What is a primary key example?

903

What are the qualities of 2nf?

975

What is before trigger?

948