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

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

885

Is join same as left join?

753

What is the default isolation level in sql server? : Transact sql

752

Is left join inner or outer by default?

761

What is java sql driver?

740

What do you understand by exception handling in pl/sql?

760

how can you see all indexes defined for a table? : Sql dba

714

What are the types of dbms?

718

how to write date and time literals? : Sql dba

698

What are stored procedures used for?

729

What are its different types of dbms?

715

What does rownum mean in sql?

722

Is mariadb a nosql database?

762

What is trigger with example?

739

Why we use stored procedure instead of query?

710