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