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 / nayana

Answer Posted / nayana

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

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Can we create a trigger on view?

841

What are two statement types in sql?

1031

Why triggers are used?

937

What is sqlite used for?

934

What does desc stand for?

1021

How does postgresql compare to mysql?

987

How many types of literals are available in pl sql?

1045

how to return query output in html format? : Sql dba

1021

What is primary key and foreign key with example?

873

What are character functions in sql?

892

What is a primary key sql?

990

How do I turn a list into a table?

906

What is a database trigger?

1017

What are expressions?

950

Can procedure in package be overloaded?

1029