sqlmonetdb

From SQL table find the same product have same product key

I have table in the following structure, I need to write SQL to find the product having multiple product keys? Can anyone please help to write the SQL?

Product Product Key
First 10
First 1
Second 2
Second 2
Third 3
Four 3
Test 5
Test 5

Expected output would be

Product
First
Third
Four
Solution

  • This is how you get using syntax from SQL Server

    SELECT Product
FROM Products
WHERE "Product Key" IN (
    SELECT "Product Key"
    FROM Products
    GROUP BY "Product Key"
    HAVING COUNT(DISTINCT Product) > 1
)
GROUP BY Product;

    These are the steps:

    1. You have to search product key that contain multiple product.
    2. We have 1 and 3.
    3. And then we get product that has product key = 1 and 3.
    4. Then, we will get this output:

    enter image description here

    This is fiddle for sql server.

    You can adjust it to monetdb syntax