分析

关键词：别名---as

用法：[列名] as [新列名]

代码

select vend_id,vend_name as vname,vend_address as vaddress,vend_city as vcity
from Vendors
order by vname