alfonso
Posts: 121
|
| Posted: 04/11/2006, 10:40 AM |
|
I want to select only 2º and 3º record in a table, but not first record.
Can you help me?
Thanks
|
 |
 |
Maybe
|
| Posted: 04/11/2006, 6:07 PM |
|
Something like this will help you on your way
sql = "select * from users"
set rs =ADO.execute(sql)
'if you don’t want the first in the database then:
rs.MoveFirst
FOR i=2 to 3
grid.label.Value = rs("yourName")
Dont forget to declare the dims
|
|
|
|
Kleberson
|
| Posted: 04/17/2006, 4:29 AM |
|
OR
SELECT TOP 2 * FROM TABLE WHERE ID NOT IN (SELECT TOP 1 FROM TABLE)
|
|
|
|
alfonso
Posts: 121
|
| Posted: 04/20/2006, 8:39 AM |
|
Thanks everybody
|
|
|
|
|
