From: "Sandeep" <sandeep@...>

> 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.

Select * from tableA where Number in
(Select Max(Number) from tableA
where Number < 1000)

HTH
Woody