Question

请问怎么用SQL 查询语句搜出一个表中同一个SaleID对应的多个GoodsID的记录？

Answer 1

select SaleID,GoodsID from Table
group by SaleID,GoodsID

Answer 2

select GoodsID from table where SaleID = v_SaleID;