SELECT *FROM EMPLOYEE_MASTERWHERE EMP_ID IN(SELECT TOP 1 MIN(EMP_ID) EMPLOYEE_IDFROM EMPLOYEE_MASTERUNION ALLSELECT TOP 1 MAX(EMP_ID) EMPLOYEE_IDFROM EMPLOYEE_MASTER);
Login to post response