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

How do you clear the screen in sql?

1088

What language is oracle sql developer?

1027

How do you select unique values in sql?

1009

What is difference between procedure and trigger?

988

Is primary key always clustered index?

1030

What trigger means?

999

what is an extent ? : Sql dba

1111

how can we find the number of rows in a table using mysql? : Sql dba

1096

What is sql clause?

1057

What are all the ddl commands?

1193

Why select is used in sql?

1027

Name the different types of indexes in sql and define them.

1162

Name the operator which is used in the query for pattern matching?

968

How can we connect an Android App to an Oracle database and use the PL/SQL procedural code?

1152

What is the purpose of the primary key?

1073