-
Notifications
You must be signed in to change notification settings - Fork 45.6k
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
sql面试题中一个作者想表达意思的疑惑 #2403
Labels
bug
Content error
Comments
进行限定的 SQL: SELECT v.vend_id, COUNT(prod_id) AS prod_id
FROM Vendors v
LEFT JOIN Products p
USING(vend_id)
GROUP BY v.vend_id
ORDER BY v.vend_id |
没注意到,当时这段代码我在牛客的编辑运行区执行也是没问题的。 |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
文章路径:数据库/基础/SQL/SQL常见面试题总结(1)/创建高级连接/列出供应商及其可供产品的数量
部分原文如下:
【问题】列出供应商(
Vendors
表中的vend_id
)及其可供产品的数量,包括没有产品的供应商。你需要使用 OUTER JOIN 和 COUNT()聚合函数来计算Products
表中每种产品的数量,最后根据 vend_id 升序排序。注意:
vend_id
列会显示在多个表中,因此在每次引用它时都需要完全限定它。文章中也写了注意要进行限定
vend_id
所在表,但是这个 sql 语句并没有做限定,是遗漏了还是故意写个错的?The text was updated successfully, but these errors were encountered: