Next and Previos Row in the Table

I have a employee table as following

EMPLOYEE_ID 			Number
EMPLOYEE_NAME		VARCHAR2(20) 

For example consider table has following data

EMPLOYEE_ID 		EMPLOYEE_NAME
111			a
333			c
555			e
666			f
888			h
999			i

I want to display Previous and Next record for the specific Employee . For Example
If I the specified employee id is 888 then I will need employee 666 and 999 I want these in single SQL .
Please email me back @ munda_73_at_yahoo.com Help will be greatly appreciated Received on Mon Jun 10 2002 - 15:33:42 CDT