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 can I get the number of records affected by a stored procedure?

579

which types of join is used in sql widely? : Sql dba

542

Suppose a student column has two columns, name and marks. How to get name and marks of the top three students.

530

what are the different index configurations a table can have? : Sql dba

575

Which is better trigger or stored procedure?

502

Is big data nosql?

514

Can there be more than one function with a similar name in a pl/sql block?

549

What are % type and % rowtype?

576

What is an inner join sql?

549

What are commit, rollback, and savepoint?

571

What are the different types of constraints?

566

What is dialect in sql?

527

What is a constraint? Tell me about its various levels.

640

What is a data manipulation language?

571

What are hotfixes and patches?

529