题解 | #别名#

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

额外收获

提交代码时，发现了一个牛客网编辑器bug。

发现过程

我的初版代码

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

提交时，发现报No slect。 几番检查、修改仍然报该错误。

去看其他博主分享的题解，发现代码基本上是一样的，cv过来却能成功提交。

另一位博主基本上一样的sql，却能成功运行的

SELECT 
    vend_id,
    vend_name as vname,
    vend_address as vaddress,
    vend_city as vcity
FROM
    Vendors
ORDER BY
    vend_name
;

结果逐步排查，发现如果初版代码，在select后加一个空格，就能成功执行并获得期望结果。

经过对其他题目的测试，有些题目有这个bug，有些题目又没有