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

Is it possible to pass parameters to triggers?

777

What are pl/sql cursor exceptions?

756

explain primary keys and auto increment fields in mysql : sql dba

712

What is indexing in sql and its types?

739

Explain foreign key in sql?

786

Show the two pl/sql cursor exceptions.

806

Explain how to use transactions efficiently : transact sql

718

How do you truncate?

660

what is the difference between mysql_fetch_object and mysql_fetch_array? : Sql dba

732

what is oracle database ? : Sql dba

737

What are the types of variable use in pl sql?

744

What is the difference between the implicit and explicit cursors?

744

What are the different set operators available in sql?

756

Explain exception handling in pl/sql?

727

Explain the uses of database trigger.

846