select * from emp where rownum>101 and rownum<121

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

Question Posted / intelligent

Answer Posted / intelligent

Is This Answer Correct ?

2 Yes

18 No

Please Help Members By Posting Answers For Below Questions

What is difference between pls_integer and integer?

927

How to avoid duplicate records in a query?

970

Is pl sql a programming language?

945

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

1025

what are the system privileges that are required by a schema owner (user) to create a trigger on a table?

1026

What are the different datatypes available in PL/SQL?

1045

Can I copy :old and :new pseudo-records in/to an oracle stored procedure?

1172

What is sql lookup?

881

Why is sql better than hql?

937

Do we need to create index on primary key?

878

what is the difference between sql and t-sql? : Transact sql

1061

What are the two different parts of the pl/sql packages?

1046

What is trigger explain with example?

999

Explian rowid, rownum?

974

what are enums used for in mysql? : Sql dba

1135