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 is the difference between cluster and non cluster index? : Sql dba

1078

Is postgresql a server?

1113

What is a clob in sql?

1065

What are the syntax and use of the coalesce function?

1275

What does rownum mean in sql?

1090

Can we create foreign key without primary key?

1039

Is sql better than access?

1069

Can %notfound return null after a fetch?

1102

What is data type in database?

1042

What is pl/sql table? Why it is used?

1079

Can we write ddl statements in functions?

1183

How is indexing done in search engines?

1023

what are date and time intervals? : Sql dba

1105

How many types of triggers exist in pl/sql?

1134

What are the set operators in sql?

1137