By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
432,035 Members | 1,555 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 432,035 IT Pros & Developers. It's quick & easy.

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

P: 5
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
Oct 19 '06 #1
Share this Question
Share on Google+
2 Replies


100+
P: 179
Not sure what you're looking for.
Oct 19 '06 #2

P: 5
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
Oct 19 '06 #3

Post your reply

Sign in to post your reply or Sign up for a free account.