select * from employees where rownum<102 minus(select * from employees

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

Question Posted / subhradeep

Answer Posted / subhradeep

select * from employees where rownum<102
minus(select * from employees where rownum<81)

Is This Answer Correct ?

2 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Is it possible for a table to have more than one foreign key?

1030

What is varchar sql?

1146

What is the life of an sql statement?

1024

Why having clause is used in sql?

978

Explain the significance of the & and && operators in pl sql.

1009

What is difference between left and right outer join?

988

What is cursor in pl sql with examples?

1034

What is the purpose of using pl/sql?

1146

How do you get column names only for a table (sql server)?

1165

Is subquery faster than join?

1014

How does a self join work?

1127

what is the difference between truncate and delete statement? : Transact sql

1064

what is commit? : Sql dba

1078

How does a covering index work?

961

What is secondary key?

934