---Swap the  consecutive rows and the first & last rows will remain same (No changes will be on 1st and last row)

---SQL INTERVIEW QUESTION

SELECT REPLICATE ('*',500) As 'INPUT TABLE'
SELECT EMPLOYEE_ID FROM [dbo].[EMPLOYEE_DATA]
SELECT REPLICATE ('*',500) As 'OUTPUT TABLE'

SELECT EMPLOYEE_ID ,
CASE WHEN EMPLOYEE_ID  = (SELECT MIN(EMPLOYEE_ID) FROM [dbo].[EMPLOYEE_DATA]) THEN EMPLOYEE_ID
WHEN EMPLOYEE_ID  = (SELECT MAX(EMPLOYEE_ID) FROM [dbo].[EMPLOYEE_DATA]) THEN EMPLOYEE_ID
WHEN employee_id %2!=0  THEN EMPLOYEE_ID-1 --Odd 
WHEN  employee_id %2=0 THEN EMPLOYEE_ID+1 --EVEN  
--ELSE employee_id
END 'SWAP_EMP_ID '
FROM [dbo].[EMPLOYEE_DATA]