带as写法

select vend_id,

vend_name as vname,

vend_address as vaddress,

vend_city as vcity from Vendors

order by vname

as 可以省略，直接写别名 select vend_id, vend_name vname, vend_address vaddress, vend_city vcity from Vendors order by vname