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 not null in sql?

1004

What does plv msg allows you to do?

1152

Can a view be mutating? If yes, then how?

1036

How many sql statements are used?

1021

What is rename in sql?

979

Which are the different types of indexes in sql?

1067

what is sql? : Sql dba

1031

what are the type of locks ? : Sql dba

971

Is sql a scripting language?

1025

How do you modify a trigger?

933

Can we commit in trigger?

987

What does truncate mean in sql?

1036

What is a crud api?

956

What is trigger and stored procedure in sql?

1045

How does index help in query performance?

1035