consider this code:---

[sql]
SELECT MAX(OFFICE_LOCATION_ID) FROM table
WHERE OFFICE_LOCATION_ID < (SELECT MAX(OFFICE_LOCATION_ID) FROM table)
[/sql]

hope it works