select * from emp where rownum>101 and rownum<121

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

Question Posted / intelligent

Answer Posted / intelligent

Is This Answer Correct ?

2 Yes

18 No

Please Help Members By Posting Answers For Below Questions

Is primary key an index?

1037

How to get list of all tables from a database?

1213

What are different types of triggers?

1186

What is assignment operator in pl sql?

1089

What are sql ddl commands?

1138

What is the command used to fetch the first 5 characters of a string?

1262

What is difference between pl and sql?

1113

Is sql pronounced sequel or sql?

1340

What are tables in sql?

1121

How do you copy a table in sql?

1113

what are the differences between binary and varbinary? : Sql dba

1085

What is localdb mssqllocaldb?

1115

What is partition in sql query?

1048

What is a parameter query?

1145

How many types of keys are there in sql?

1091