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

Is primary key a clustered index?

710

How many types of normalization are there?

669

What is clause in sql?

759

What is bulk compiling in pl/sql.?

799

Define commit, rollback and savepoint?

765

What is trigger types in sql?

720

how to run 'mysql' commands from a batch file? : Sql dba

777

What is sql dialect?

741

How do you remove duplicate records from a table?

676

How many types of triggers exist in pl/sql?

730

What is a function in oracle pl sql?

724

What are the different sql languages?

740

What are sql objects?

738

Is mariadb nosql?

767

What are the possible values for the boolean data field?

693