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

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

Question Posted / swapna

Answer Posted / swapna

select * from emp where rownum<121
minus (select * from empwhere rownum<100);

Is This Answer Correct ?

11 Yes

6 No

Please Help Members By Posting Answers For Below Questions

Are stored procedures faster than queries?

898

What are sql ddl commands?

1019

What are the advantages of stored procedure?

946

What is the difference between delete and truncate commands?

975

Can we use commit inside a trigger?

1027

Is pl sql useful?

931

Can a table have no primary key?

1009

What is coalesce in sql?

970

What is a database event trigger?

1081

how do you control the max size of a heap table? : Sql dba

921

What is a composite primary key?

1030

What are sql commands?

935

what is a constraint? : Sql dba

1105

What is trigger in sql? Explain

941

Can you join a table to itself?

1030