题解 | #纠错2#
纠错2
https://www.nowcoder.com/practice/ec773e81e8084d70bc62fd9012eabae5
本题意在考察MySQL的执行顺序，where 在 order前执行 select vend_name from Vendors where vend_country = 'USA' and vend_state = 'CA' order by vend_nameMySQL语法顺序：select[distinct]
from
join（如left join）
on
where
group by
having
union
order by
limit
MySQL执行顺序：
from
on
join
where
group by
having
select
distinct
union
order by
on
join
where
group by
having
select
distinct
union
order by
参考链接：
https://blog.csdn.net/weixin_44322234/article/details/122582742
腾讯公司福利 1143人发布