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

Answer Posted / alex

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

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is a join? : Sql server database administration

545


How do I install only the client tools of sql server 2000?

553


Why I have to use stored procedures?

597


How raid can influence database performance?

575


Write a sql query to delete duplicate records from a table called table1

586






What is a collation?

594


Why the trigger fires multiple times in single login?

723


How to write a query with a right outer join in ms sql server?

478


Tell me about pre-defined functions of sql?

693


List some of the rules that apply to creating and using a ‘view’

499


What are the properties and different types of sub-queries?

564


Can You Use Data Mining Models In Ssrs?

97


When a primary key constraint is included in a table, what other constraints does this imply?

603


What are the common performance issues in sql server?

505


Differentiate between a local and a global temporary table?

541