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 to write a single statement that concatenates the words ?hello? And ?world? And assign it in a variable named greeting?

1096

What are different types of statements supported by sql?

1165

What is case function?

1040

Which constraints we can use while creating database in sql?

1081

What are the types of variable use in pl sql?

1080

What is sql and also describe types of sql statements?

1066

What is the difference between an inner and outer join?

1012

how to increment dates by 1 in mysql? : Sql dba

978

What is the purpose of the partition table?

1049

What are primary key and foreign key and how they work?

977

What is the sql case statement?

1004

How do I find duplicates in a single column in sql?

1020

What packages are available to pl/sql developers?

1058

What is sql and explain its components?

1066

What are the steps for performance tuning.

1337