How to retrieve range of 10th rows to 20 th rows from total
rows from a database table.? (Not from Dataset)
Answer Posted / santosh dwivedi
select * from
(
select rownum r,a.* from TableName a
)
where r>=10 and r<=20
Is This Answer Correct ? | 14 Yes | 10 No |
Post New Answer View All Answers
Is it possible for a stored procedure to call itself or recursive stored procedure?
Is it true that rules do not apply to data already existing in a database at the time the rule is created?
What is normalization and denormalization in sql server?
What is the difference between local and global temporary tables?
Define self join in sql server joins?
What is the purpose of optimization?
How much memory that we are using in Logshipping Concept?
What is difference between clustered and non clustered index?
List the different types of collation sensitivities in sql server?
What are sparse columns?
What do you know about normalization and de- normalization?
State a few properties of relational databases?
Types of Authentications in Sql Server? How user gets authenticated through windows authentication?
How to see the event list of an existing trigger using sys.trigger_events?
What are the diifferences between the ms sql server vs mysql?