题解 | #别名#
别名
http://www.nowcoder.com/practice/3a4ec448b6f74dc49f886692887aaf84
带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
