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
- 26915 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 makes a good primary key?
Is sqlexception checked or unchecked?
What is rank () in sql?
What is user defined functions?
What is the difference between partition and index?
How do I filter in sql profiler?
How to change sql*plus system settings?
How do I add a database to sql?
Is primary key an index?
What is pessimistic concurrency control? : Transact sql
Write a sql query to convert all character to uppercase after hypen.
explain normalization concept? : Sql dba
how to see the create table statement of an existing table? : Sql dba
How to sort the rows in sql.
Mention what does the hierarchical profiler does?
