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 is difference between pls_integer and integer?

964

What are the disadvantages of file system?

1267

What is the difference between inner join and natural join?

1006

When are we going to use truncate and delete?

989

how to create a table index in mysql? : Sql dba

1061

How do you select unique values in sql?

999

what are string data types? : Sql dba

1045

Why we use cross join?

953

Write an sql query to select all records from the table?

1030

List the ways to get the count of records in a table?

900

give the syntax of grant and revoke commands? : Sql dba

1153

how many groups of data types? : Sql dba

1026

Define concurrency control. : Transact sql

1191

what is primary key? : Sql dba

1029

what is index? : Sql dba

1006