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 aggregate functions in sql?

1092

what is self join and what is the requirement of self join? : Sql dba

1079

Why is sql better than hql?

923

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

874

Why trigger is used in sql?

919

what is the difference between a local and a global temporary table? : Sql dba

1006

What is delete command in sql?

1053

Explain about various levels of constraint.

889

How do I count rows in sql query?

940

What are different methods to trace the pl/sql code?

1051

What are the sql aggregate functions?

1068

What is sql table?

906

How to read/write files from pl/sql?

994

what is single byte over head in oracle..?

2346

Is oracle and sql same?

956