Change the name of the column while displaying the data from database

SELECT 'Name'= EmpName, 'ID NO' = EmpID From Schema.Table1