A table has 150 records. How do you retrieve 100th row to
120th row from that table ?
- 21 Answers
- 21927 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
What are the dml statements?
how can we know the number of days between two given dates using mysql? : Sql dba
What is the use of double ampersand (&&) in sql queries? Give an example
How do you modify a table in sql?
What are the uses of merge?
How do you respond to dementia behavior?
What is restrict in sql?
What is an invalid partition table?
What is sql*loader and what is it used for? : aql loader
What is trigger with example?
what is the use of anchoring object? what r the difference between anchoring object & enclosing object? can any one tell me all the details?
What is the difference between view and stored procedure?
What is the meaning of disabling a trigger?
Explain normalization and what are the advantages of it?
What is the difference between function and procedure in pl/sql?
