题解 | #纠错2#
纠错2
https://www.nowcoder.com/practice/ec773e81e8084d70bc62fd9012eabae5
SELECT vend_name FROM Vendors WHERE vend_country = 'USA' AND vend_state = 'CA' ORDER BY vend_name
考察sql的语法顺序:
select[distinct]
from
join（如left join）
on
where
group by
having
union
order by
limit
sql的执行顺序:
from
on
join
where
group by
having
select
distinct
union
order by
投递BOSS直聘等公司6个岗位