select * from emp where rownum<121 minus(select * from emp where rownum

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

Question Posted / laks

Answer Posted / laks

select * from emp where rownum<121
minus(select * from emp where rownum<101)

Is This Answer Correct ?

34 Yes

4 No

Please Help Members By Posting Answers For Below Questions

What does varchar include?

934

what are the t string functions available in tsql? : Transact sql

990

What does where 1/2 mean in sql?

1048

What is meant by temporal data?

939

how can we destroy the session, how can we unset the variable of a session? : Sql dba

980

What is the difference between the repeatable read and serializable isolation levels? : Transact sql

1075

What is a mutating table and a constraining table?

1088

How do I copy a table in sql?

964

What is keys and its types?

1059

What are the operators used in select statements?

1043

how to see the create table statement of an existing table? : Sql dba

986

Can we create table inside stored procedure?

937

What is the sql*loader? : aql loader

1039

What is pl sql collection?

945

Which is better join or subquery?

1118