string myquery="SELECT * FROM [Employee] WHERE ([Table

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

Question Posted / alex

Answer Posted / alex

string myquery="SELECT * FROM [Employee] WHERE
([Table_Field]<=10 AND [Table_Field]<=20)"

Is This Answer Correct ?

2 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What does the automatic recovery do?

578

Delete duplicate rows without using rowid.

1074

What is a db view?

520

Where views are stored in sql server?

562

How can we call UDF(User Define Function) using C# code in ASP.net ?

5946

How to backup encryption key ?

127

How to delete exactly duplicate records from a table?

606

What is the minimum recommended amount of ram for sql server 2012 enterprise?

514

Is sql server free?

526

What is a print index?

502

What is extent? Types of extents?

594

How will you find out if there are expensive SQL statements running or not?

585

How to create database with physical files specified in ms sql server?

544

How to Sync Two SQL Azure Databases?

101

How to add a new dsn with the odbc driver for sql server?

554