Try this

SELECT EmpID, EmpName from Employee

UNION

SELECT NULL AS EmpID, 'ALL' AS EmpName

ORDER BY EmpName

And SET default value as NULL