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
What command would you use to add a column to a table in sql server?
How many triggers are possible per table?
How check triggers in sql server?
What is perspective, have you ever created perspective? : sql server analysis services, ssas
Describe in brief authentication modes in sql server.
What are the disadvantages of indexes?
What happens if you add a new index to large table?
What is onf in normalization form?
What are the difficulties faced in cube development? : sql server analysis services, ssas
What is the size of transaction log file?
What is the impact on other user sessions when creating indexes?
you have couple of stored procedures that depend on a table you dropped the table and recreated it what do you have to do to reestablish those stored procedure dependencies?
What is attribute relationships, why we need it? : sql server analysis services, ssas
How to set a database state to offline in ms sql server?
what is the difference between openrowset and openquery?