• How about this Jeff ???

    ; WITH cte AS

    (

    SELECT *

    ,RowNum = ROW_NUMBER() OVER( PARTITION BY eid ORDER BY eno )

    ,GrpCnt = COUNT(*) OVER( PARTITION BY eid )

    FROM emp

    )

    SELECT eno , eid

    FROM cte

    WHERE RowNum <= 2 AND GrpCnt > 2