Question

oracle 多表查询去重的问题

请问这个sql怎么优化才能把重复的数据去掉。
SELECT "shop_goods"."id", "C"."name", "shop_goods"."goods_sn" FROM "shop_goods"INNER JOIN "goods_details" "B"ON "shop_goods"."goods_sn" = "B"."sn"INNER JOIN "goods" "C"ON "B"."sn_style" = "C"."sn_style"WHERE "shop_goods"."goods_sn" IN('11019136027980','21075991861779');

Answer 1

你这个不算重复，毕竟前面的shop_goods.id不一样。

Answer 2

你可以 group by name 取最大或最小的goods_sn

Answer 3

你这个哪里重复了啊？？？name前面有编号啊？？