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 many levels of sp nesting is possible?

1059

What is inline variable assignment?

1035

Which is the best place or learning center for MS SQL?????In Bangladesh?????

2077

How to write character string constants or literals in ms sql server?

1031

How to download and install the scaled-down database adventureworkslt?

992

What is subquery explain with example?

1068

How to identify current user in ssrs report?

406

What is nonclustered index with included columns ?

970

How to connect to a sql server using odbc_connect()?

1161

What options are there to delete rows on the publisher and not on the subscriber? : sql server replication

1222

How to test subquery results with the exists operator?

1108

Tell me about pre-defined functions of sql?

1113

How is sql used in sql server?

1018

how can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A

1686

What is normalization of database? What are its benefits?

1029