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 graph sql?

1040

what is the maximum length of a table name, database name, and fieldname in mysql? : Sql dba

1167

How does a covering index work?

1012

what are the advantages and disadvantages of views in a database? : Sql dba

1075

What are the possible values that can be stored in a boolean data field?

1043

is mysql query is case sensitive? : Sql dba

1164

What is output spooling in sql*plus?

1092

What are the popular database management systems in the it industry?

1038

What is the primary key?

1003

Why do we need unique key in a table?

1008

Are stored procedures faster than dynamic sql?

1107

What is sql trigger example?

1115

How do you use a while loop in pl sql?

1056

Explain what is an index?

1106

How do I enable sql encryption?

1073