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
- 27441 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 is schema in sql example?
What is the current version of postgresql?
What are actual parameters and formal parameters?
What are the steps for performance tuning.
How do you use a while loop in pl sql?
What is the advantage of index in sql?
what is primary key? : Sql dba
What is relationship? How many types of relationship are there?
What kind of join is join?
What is pragma in pl sql?
Why is sql important?
when is the use of update_statistics command? : Sql dba
How run sql*plus commands that are stored in a local file?
Explain the difference between triggers and constraints?
Explain the difference in execution of triggers and stored procedures?
