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
- 27656 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / jayanth
select * from (select a.*, row_number() over (order by empno) rn from emp a) where rn between 100 and 120;
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How do I make sql search faster?
Table A Table B 1 1 2 1 3 1. Union & union all --> A Union B , A Union all B 2. Minus , Intersect --> A minus B , B Minus A , A Intersect B 3. Joins A join B , A Left Join B A Right Join B , A full Join B 4. %Type - Uses & Benifit 5. Truncate & Delete 6. Pragma Autonomus Transaction 7. how to Perform DDL from function or procedure 8. Can we have DML inside Function 9. Rank & Dense Rank diffrence 10. Water Mark in Oracle 11. Index , Can we have index in all column of table if no then why ?
How do you write a complex sql query?
What is pl sql commands?
What is localdb mssqllocaldb?
What are the types of sql commands?
What is clustered index in sql?
Why do we go for stored procedures?
What is an inner join sql?
Is pl sql different from sql?
What are procedures used for?
Is pl sql useful?
What does pragma mean?
How do I clear the screen in sql plus?
What is record type in pl sql?
