轻飘飘过wind

分类

/ 注册

全部文章（共2篇）

题解 | #精简SQL#

对3个表进行内连接 select distinct(ct.cust_email) from Customers as ct inner join Orders as o on ct.cust_id...

Mysql

2022-08-31

3 492

题解 | #返回购买价格为 10 美元或以上产品的顾客列表#

使用内连接，筛选条件放到on里进行判断 select o.cust_id from Orders as o inner join OrderItems as ot on o.order_num&nb...

Mysql

2022-08-31

10 323