SELECT * FROM EMPLOYEES WHERE EMPLOYEE

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

Question Posted / gourav

Answer Posted / gourav

SELECT * FROM EMPLOYEES
WHERE EMPLOYEE_ID BETWEEN 120 AND 150;

Is This Answer Correct ?

2 Yes

5 No

Please Help Members By Posting Answers For Below Questions

What are the two types of exceptions in pl/sql?

1004

What is duration in sql profiler trace?

1046

What are the different tcl commands in sql?

1128

what are the different type of sql's statements ? : Sql dba

893

Why do we use partitions in sql?

1005

What is a parameter query?

1039

What is bind reference and how can it be created?

992

Can we insert delete data in view?

915

How many types of primary keys are there?

1003

What is the unique index?

1034

How many row comparison operators are used while working with a subquery?

1001

Which kind of parameters cannot have a default value in pl sql?

1094

How do you copy a table in sql?

1036

Does view store data in sql?

927

What is a database trigger?

1036