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 to convert a numeric expression from one data type to another?

1093

How to create new tables with "select ... Into" statements in ms sql server?

1048

What changes in the front end code is needed if mirroring is implemented for the high availability? : sql server database administration

1082

What are commonly used odbc functions in php?

1058

Explain the concept of recursive stored procedure.

1023

Can sql servers link to other servers like oracle?

894

How to create user defined functions with parameters?

1298

How do I start sql server 2017?

986

What is meant by Active-Passive and Active-Active clustering setup?

1273

Explain table valued parameters in sql server? Why tvp used?

1068

what is the difference between openrowset and openquery?

1159

You schedule a job to run every minute what will happen if the first job runs more than 1 min? Will the second instance of the job start?

1089

What is the purpose of self join?

1035

How to delete multiple rows with one delete statement in ms sql server?

1075

What are system databases into sql server (2005/2008) : sql server database administration

1053