Re: Prev and Next row

[Peter Brawley]

> I have following database (example)

That's a table, not a database.

> I need to get data from previous and next rows, not from actual one as this code do [sic] at this moment.

'Previous' and 'Next' are meaningless unless the query imposes order with an Order By or Group By clause, eg ... select ... from trad where ... order by ciid.

So decide which column(s) you wish to order by, then add that clause to your query.