DB Question just asking

[iehjsucker]

is it possible to select the 5th record until the 30th record in a sql query?

[robertx]

Not sure if there is a shortcut.

I would load the query into a datatable and iterate through the datatable as follows:

Dim str As String
Dim myDataTable As New DataTable
 
'Populate your datatable with all rows 
 
For i = 4 to 29 'row numbers 5 to 30
   'assign the value of the first field in row i to str
   str  = myDataTable.Rows(i).Item(0)             
Next

[iehjsucker]

i know that, i am just asking on the sql part if it is possible?

[dannywooly]

Check out the top method not sure if you can amend that?

[iehjsucker]

SELECT *
FROM (Select top 30 * from Products) where productID > 4;

[dannywooly]

Did it work??

[iehjsucker]

it did work. Try it on your Northwind database. it will work:-0

[dannywooly]

Glad i could help!

[robertx]

SELECT *
FROM (Select top 30 * from Products) where productID > 4;

It will work provided that a product with ProductID between 1 and 4 (inclusive) has not been deleted. If this is the case, then ProductID 5 can at most be the fourth record and should be excluded but will not be excluded according to the WHERE clause above.

[robertx]

You could populate a datatable with "Select top 30 * from Products" then:

For i = 0 to 3
myDataTable.Rows.RemoveAt(i)
Next

to remove the first 4 rows.