SQL - usning next row's value ?? help

[Poul Waagner]

Hej
I have a sql-plus problem - how can i fetch record #2 under condition that record #3 are not with 'Y' in status - shall i use a subselect - or are there a way to use the indexed field.


Item number status itemno (unique index)
----------------------------------
1 DI11 111
2 PR10N 123
3 PR10Y 144
4 PR10N 155
...... thousands more rows

[Jeanne Boyarsky]

I would go with a subselect.