求一段SQL 代码

[谁学逆向工程]

在 tbGoods 表中有三列
1、GoodsName
2、BaseBarCode
3、SalePrice

1是商品名称，2是商品条码，3是售价


大米和淀粉的条码都是7位（len(BaseBarCode)=7 ）
现在只要在大米和淀粉中查询（GoodsName Like '%大米%' GoodsName Like '%淀粉%' ）
查出哪些大米的售价等于淀粉

[FainSheeg]

select * from tbgoods where goodsname like '%大米%' and saleprice in(select saleprice from tbgoods where goodsname like '%淀粉%'）

[谁学逆向工程]

引用 1 楼 yangliu0512 的回复:

select * from tbgoods where goodsname like '%大米%' and saleprice in(select saleprice from tbgoods where goodsname like '%淀粉%'）

对应的等价的淀粉没出来啊

[FainSheeg]

select * from tbgoods where (goodsname like '%大米%' or goodsname like '%淀粉%') and saleprice in(select saleprice from tbgoods where goodsname like '%大米%' and saleprice in(select saleprice from tbgoods where goodsname like '%淀粉%')) order by saleprice,goodsname