A table has 150 records. How do you retrieve 100th row to
120th row from that table ?
- 21 Answers
- 24620 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / ajit nayak
select rn, ename
from (select rownum rn, ename
from emp)
where rn between 3 and 7;
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is exception? What are the types of exceptions?
what are the limitations of identity column? : Transact sql
Is it possible to create startup or shutdown trigger for on-schema?
Explain clause in sql?
What is trigger types of trigger?
What are the ways on commenting in a pl/sql code?
What is trigger in pl sql with examples?
What is difference between inner join and cross join?
what are all the different types of indexes? : Sql dba
Why is sql better than hql?
What is a unique key?
What is auto increment?
What are predefined functions in sql?
How do you take the union of two tables in sql?
How do I write a sql query in pgadmin 4?
