求一段SQL 代码

[谁学逆向工程]

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

第一个是商品名称，第二个是商品条码，第三个是售价

大米和淀粉的 BaseBarCode 长度都是7位（ len(BaseBarCode)=7 ），现在是要在大米和淀粉中查询（GoodsName like '%淀粉% GoodsName like '%大米%''）其余不要。查出大米的售价等于淀粉的售价的结果，显示出这3列。

[不放弃的LMQ]

  SELECT one.GoodsName
      ,one.BaseBarCode
      ,one.SalePrice
	  ,two.GoodsName
      ,two.BaseBarCode
      ,two.SalePrice
  FROM [TestDB].[dbo].[ShangPing] one inner join [TestDB].[dbo].[ShangPing] two on one.SalePrice = two.SalePrice 
  where one.GoodsName  like '%大米%'and two.GoodsName like '%淀粉%';

[qq_34292420]

select *from (select GoodsName,BaseBarCode,SalePrice from tbGoods where GoodsName like '%淀粉% or GoodsName like '%大米%) s1 group by SalePrice having count(*)>2

[风吹腚腚凉]

赞同group by 价格

[qq_34292420]

你修修改改应该就可以了

[谁学逆向工程]

引用 2 楼 qq_34292420 的回复:

select *from (select GoodsName,BaseBarCode,SalePrice from tbGoods where GoodsName like '%淀粉% or GoodsName like '%大米%) s1 group by SalePrice having count(*)>2

有语法错误

[sdfgrtyu]

SELECT one.GoodsName
      ,one.BaseBarCode
      ,one.SalePrice
      ,two.GoodsName
      ,two.BaseBarCode
      ,two.SalePrice
  FROM [TestDB].[dbo].[ShangPing] one inner join [TestDB].[dbo].[ShangPing] two on one.SalePrice = two.SalePrice 
  where one.GoodsName  like '%大米%'and two.GoodsName like '%淀粉%';