from HumanResources.Employee
--列的值升序排列
select EmployeeID from HumanResources.Employee
order by EmployeeID...as 'Eid',Title as 'TName' from Emp
select 'E'=EmployeeID,'T'=Title from Emp
select EmployeeID 'EEE'...,Title 'TTT' from Emp
select EmployeeID , 'EEE' ,Title ,'TTT' from Emp
select EmployeeID , 'EEE'as...,isnull(EndDate,0) as EDate from EDH
----------
select EmployeeID,coalesce(EndDate,StartDate,...h
order by EmployeeID asc