Interested to Buy Any Domain ? << Click Here >> for more details...
A table has 150 records. How do you retrieve 100th row to
120th row from that table ?
- 21 Answers
- 27653 Views
- IBM, I also Faced
- E-Mail Answers
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)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the conditions an underlying table must satisfy before a cursor can be used by a positioned update or delete statement? : Transact sql
how do you know the version of your mysql server? : Sql dba
Is it possible to remove child records without removing master table records...the two having pk,fk relationship?
What are the two types of periodical indexes?
How can a function retun more than one value in oracle with proper example?
Is sql a microsoft product?
Explain the types of joins in sql?
What is the advantage of nosql?
what is sql in mysql? : Sql dba
what is the difference between truncate and delete statement? : Transact sql
how to enter binary numbers in sql statements? : Sql dba
How do you create a unique index?
how to include numeric values in sql statements? : Sql dba
How do temporal tables work?
How to look at the current sql*plus system settings?
