Answer Posted / nancy

select * from (
select tn.*, rownum rd from emp tn ) where rd between 100 and 200;

or

select * From (select tn.* from emp tn where rownum <201
minus
select tn.* from emp tn where rownum <100)

What are the conditions an underlying table must satisfy before a cursor can be used by a positioned update or delete statement? : Transact sql

1003

---

how do you know the version of your mysql server? : Sql dba

1007

---

Is it possible to remove child records without removing master table records...the two having pk,fk relationship?

1271

---

What are the two types of periodical indexes?

940

---

How can a function retun more than one value in oracle with proper example?

1079

---

Is sql a microsoft product?

954

---

Explain the types of joins in sql?

1036

---

What is the advantage of nosql?

1061

---

what is sql in mysql? : Sql dba

1199

---

what is the difference between truncate and delete statement? : Transact sql

1073

---

how to enter binary numbers in sql statements? : Sql dba

981

---

How do you create a unique index?

1051

---

how to include numeric values in sql statements? : Sql dba

1103

---

How do temporal tables work?

966

---

How to look at the current sql*plus system settings?

1157

---