select * from ( select rownum r,a.* from TableName a ) where r>=10 a

How to retrieve range of 10th rows to 20 th rows from total
rows from a database table.? (Not from Dataset)

Question Posted / santosh dwivedi

10 Answers
15632 Views
Cognizant, Infosys, I also Faced
E-Mail Answers

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

Please Help Members By Posting Answers For Below Questions

How do you start single user mode in clustered installations?

523

How to create function with parameter in sql server?

557

What Are the Main Features of SQL Azure?

What is a filestream?

558

What are the 10 characteristics of data quality?

531

what are acid properties? : Sql server database administration

495

What is plan freezing?

586

how to determine the service pack currently installed on sql server? : Sql server database administration

567

Define cursor locking

550

Explain nested stored procedure. Syntax and an example for create nested stored procedure?

530

whats the maximum size of view state??

1724

Write an sql query for deleting duplicate rows?

551

Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60

1722

What action plan is preferred if sql server is not responding?

537

How we create SQL Server 2005 Reporting Services ? Give me Sample

1573