I have a table with field Number as primary key.
I want to get a record prior to specified number, something like

select * from tableA
where Number < 1000

I don't know what the previous number is.

Regards

Sandeep

Software Developer
CFL
sandeep@...
http://www.cfl.co.nz