select * from emp where rownum<151 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 / sravan

Answer Posted / sravan

select * from emp where rownum<151
minus(select * from emp where rownum<121)

Is This Answer Correct ?

13 Yes

14 No

Please Help Members By Posting Answers For Below Questions

What is the use of <> sql?

980

explain the difference between bool, tinyint and bit. : Sql dba

1000

Explain what is a field in a database and record in a database?

1097

How to run sql commands in sql*plus?

1180

What is the maximum number of rows in sql table?

1030

How do I install sql?

997

What is a composite primary key?

1093

Why do we use function in pl sql?

1061

What is a native sql query?

1069

What is the maximum size of sqlite database?

1111

How do I get sql certification?

972

What is sql server and ase?

1022

How do I find duplicates in two columns?

1169

why does the selected column have to be in the group by clause or part of an aggregate function? : Sql dba

1110

What are the types of join in sql?

1103