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

What is set serveroutput on in pl sql?

1272

What are character functions in sql?

920

Are stored procedures faster than queries?

929

How can we solve sql error: ora-00904: invalid identifier?

1234

how to dump a table to a file with 'mysqldump'? : Sql dba

1022

Can procedure in package be overloaded?

1063

What are the popular database management systems in the it industry?

978

How do I remove sql plus from windows 10?

1075

Can we use view in stored procedure?

886

What is package in pl sql?

999

Define join and name different types of joins?

987

How do you break a loop in pl sql?

1030

what are the authentication modes in sql server? : Sql dba

1043

Can cursors be part of a trigger body?

1628

How can get second highest salary in sql?

964