I need to get a row of a table by it's position

[bfirpo]

I need to get a row of a table by it's position i mean the id it's not in order and if i have 30 fields and i want the field number i don't know 13 what it's the sql sentence for that or working in . net thanks. sorry for the english i'm from uruguay

[comteck]

Not sure what you're looking for.

[bfirpo]

ok how can i get the register nº 10 whithout finding in all the registers of the table.?
In mySQL would be: SELECT * FROM mytable LIMIT 1 OFFSET 10
In ORACLE: SELECT * FROM mytable ROWNUM 10

In ACCESS : ........

I can't find by the id because it's not correlative