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

Answer Posted / gourav

SELECT * FROM EMPLOYEES
WHERE EMPLOYEE_ID BETWEEN 120 AND 150;

Is This Answer Correct ?

2 Yes

5 No

Please Help Members By Posting Answers For Below Questions

What are pl/sql packages?

1107

how do you control the max size of a heap table? : Sql dba

986

How to rename a column in the output of sql query?

1072

What is pivot table in sql?

1115

What is pls_integer in pl sql?

1108

what is a trigger in mysql? Define different types of trigger. : Sql dba

1074

what are the differences between procedure-oriented languages and object-oriented languages? : Sql dba

1055

What is data definition language?

1097

How do I pipe the output of one isql to another?

1008

what are the differences between binary and varbinary? : Sql dba

1049

what is the difference between a having clause and a where clause? : Sql dba

1092

What is a pragma statement?

1267

What is on delete set null?

1095

How do I truncate a word?

1094

What are the limitations of sql express?

1074