A table has 150 records. How do you retrieve 100th row to
120th row from that table ?
- 21 Answers
- 24626 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
Explain lock escalation? : Transact sql
What is sql and explain its components?
What are different types of functions in sql?
Explain what is a view?
what is not null constraint? : Sql dba
what is 'mysqlimport'? : Sql dba
What is int identity in sql?
What is anonymous block in sql?
What are reports usually used for?
What is sqlcommand?
Can variables be used in sql statements?
How can we debug in PL/SQL?
What is server name sql?
What is the starting oracle error number? What is meant by forward declaration in functions?
What is pl/sql table? Why is it used?
