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 josih

Answer Posted / gourav josih

select *from employees
where employee_id between 120 and 150;

Is This Answer Correct ?

4 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What are all the common sql functions?

998

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

1025

What are predefined functions in sql?

1023

What is the use of sql trace?

936

How do I kill a query in postgresql?

1072

What are the disadvantages of file system?

1239

What is the purpose of cursors in pl/sql?

1122

Is it possible to read/write files to-and-from PL/SQL?

1084

What is difference between hql and sql?

1052

What are % type and % rowtype?

1020

What is the purpose of my sql?

937

How do I turn a list into a table?

944

What does cursor do in sql?

1003

What is difference between function and trigger?

1023

Which join is like an inner join?

1011