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
- 28311 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / d
select *
from (select rownum row_num
,tab.*
from table tab)
where row_num between 100 and 120
| Is This Answer Correct ? | 7 Yes | 2 No |
Post New Answer View All Answers
Is full outer join same as cross join?
what are the non-standard sql commands supported by 'mysql'? : Sql dba
What is a constraint? Tell me about its various levels.
How to run sql commands in sql*plus?
What are user defined functions?
Explain what is a database?
How do I enable sql encryption?
how to write date and time literals? : Sql dba
Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me
What does seeding a database mean?
What does trigger mean in psychology?
how to get @@error and @@rowcount at the same time? : Sql dba
What is function and procedure in pl sql?
Explain locks? : Transact sql
How do I view a view in sql?
