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 are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture

1005

Tell me what is difference between clustered and non clustered index?

944

Explain Geometry datatype in sql server 2008 with example

989

Name and describe few console utilities for ssrs?

284

What are date and time data types in ms sql server?

1094

How to include date and time values in sql statements?

1085

Does the order of columns in update statements matter?

913

How to how to convert numeric expression data types using the convert() function??

1051

What is the full meaning of dml?

952

What is difference between order by and group by?

1006

Can you use order by when defining a view?

977

How to filter records of table in SQL SERVER?

1086

When we should use @@error?

966

Explain data warehousing in sql server?

1049

How efficient you are in oracle and SQL server?

1154