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

How can you set the threshold at which sql server will generate keysets asynchronously?

938

explain different types of constraints? : Sql server database administration

913

What is difference between foreign key and unique key?

960

What are the different types of sub-queries?

994

what's the difference between delete table and truncate table commands? : Sql server database administration

919

Difference between Logical Page and Physical Page in SSRS.

459

What is a view in sql?

924

What is the temp table?

864

Explain about local stored procedure?

900

How to delete a login name in ms sql server?

1001

How many types of local tables are there in sql server?

886

Explain what are the basic functions for master, msdb, model, tempdb databases?

910

Tell me what is use of except clause? How it differs from not in clause?

898

How to find related tables in sql server?

870

How to test odbc dsn connection settings?

964