Position to records in Firebird database

[finalist]

For example: there are 100 records in a Firebird database.
I do execute the SQLQuery: 'select W from TRIANGLE order by W asc'
I need to position to 50 and 51 record and get the average value of both
But the record count may to be 2, 3, 4 ....
Is there some solution for this ?
Thank you !

[bluewolf]

Hi finalist,

I had to check on the internet as I don't use Firebird.

You shoud try with: 'select first 2 skip 49 W from TRIANGLE order by W asc'

According to firebird documentation here it should work.
You can check the link. There are several examples about it.

I hope it helps.

Regards.
Alberto.

[finalist]

Thanks bluewolf !
Your solution works fine for me !