value of field in position n
Posted on 2012-03-23
Let´s say I have a table XYZ with 2 fields and 3 records, say:
I want to select 'cat' with an SQL statement like:
"select field2 from tableXYZ where field1 = [value of field1 in n-row] order by field1 asc"
My question is: how should I "fill the bold place", please?
(I want a general solution to this case, in which I am able to find which is the number present in the record of field1 when we are looking at the n-th row, where n is given.)