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 are the different types of normalization?

804


How to create percentile function?

124


What are the methods used to protect against sql injection attack?

795


Explain how to send email from sql database?

722


What is the difference between char and varchar2 datatype in sql?

738






Which are the important points to note when multilanguage data is stored in a table?

679


What is a linked server in sql server?

754


Explain throw statement in sql server 2008?

733


Find columns used in stored procedure?

695


What are the different types of sql server replication? : sql server replication

803


define and explain the differences between clustered and non-clustered indexes.

816


How many clustered indexes there can be on table ?

747


What are the basic features of a trigger in ms sql server?

788


What is difference between clustered and non clustered index?

697


Can we take the full database backup in log shipping?

713