SQL
l_fireworks
一个喜欢音乐的程序猿
展开
-
多表查询SQL
例子:SELECT tmp2.goods_number,tmp2.goods_name,C.product_name,tmp2.chukufrom ( select goods_number,goods_name,sum(goods_quantity) AS chuku from ( SELECT distinct A.order_number,B.goods_name,B.goods_number,B.goods_quantity from oms_order AS A, o原创 2021-10-25 13:19:01 · 189 阅读 · 0 评论 -
SQL语句怎么查询出某个字段重复出现两次以上的数据
select *from表where字段 in(select 字段from表group by 字段having count(1)1)原创 2021-08-06 16:59:34 · 18970 阅读 · 0 评论