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

How many types of sql are there?

979

How much ram can sql express use?

964

How do I turn a list into a table?

946

What are literals in sql server?

1140

tell us something about heap tables. : Sql dba

1077

What is a crud api?

940

What is sqlerrd?

956

Is left join faster than join?

1035

how to convert numeric values to character strings? : Sql dba

1085

What is sql not null constraint?

1010

How do you declare a variable in pl sql?

1008

what is the difference between join and union? : Sql dba

1089

what is the difference between clustered and non clustered index in sql? : Sql dba

1107

describe mysql connection using mysql binary. : Sql dba

1047

what is online transaction processing (oltp)? : Sql dba

979