SQL - How to Output Rows that Share Same Value in Certain Column

Question

I have a problem where we have different quantities of a product that share the same price. I want to find the products that share the same price for different quantities.

E.G. We have output Table Name: Goods

Product	Quantity	Price
A	5	1.99
A	10	1.99
A	15	12.99
B	5	3.99
B	10	7.99
B	15	3.99

I want a result that only shows rows where the quantity is different and the price is the same.

E.G.

Product	Quantity	Price
A	5	1.99
A	10	1.99
B	5	3.99
B	10	3.99

How am I able to get this output?

adrianMoskal · Accepted Answer · 2022-07-06 18:27:07Z

1

Perfect example for exists

SELECT *
FROM Goods a
WHERE EXISTS (SELECT *
              FROM Goods b
              WHERE a.Product = b.Product AND a.Price = b.Price AND a.Quantity <> b.Quantity);

answered Jul 6, 2022 at 18:27

adrianMoskal

5496 silver badges23 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Hogan · Accepted Answer · 2022-07-06 18:41:21Z

0

You can use a windowing function -- it acts like a group by per row.

SELECT *
FROM Goods
WHERE COUNT(*) OVER (PARTITION BY Product, Price) > 1

answered Jul 6, 2022 at 18:41

Hogan

70.7k10 gold badges83 silver badges119 bronze badges

Collectives™ on Stack Overflow

SQL - How to Output Rows that Share Same Value in Certain Column

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related