Sfrgttk

What does it mean to make a bootable LiveUSB?

Official degrees of earth’s rotation per day

Using "wallow" verb with object

What is IP squat space

How to deal with taxi scam when on vacation?

Russian cases: A few examples, I'm really confused

Am I not good enough for you?

I need to drive a 7/16" nut but am unsure how to use the socket I bought for my screwdriver

Is it normal that my co-workers at a fitness company criticize my food choices?

Why are there 40 737 Max planes in flight when they have been grounded as not airworthy?

Provisioning profile doesn't include the application-identifier and keychain-access-groups entitlements

How to write cleanly even if my character uses expletive language?

Professor being mistaken for a grad student

How do I hide Chekhov's Gun?

Be in awe of my brilliance!

Where is the 1/8 CR apprentice in Volo's Guide to Monsters?

RegionDifference for Cylinder and Cuboid

What are the possible solutions of the given equation?

Good allowance savings plan?

Sword in the Stone story where the sword was held in place by electromagnets

What is the greatest age difference between a married couple in Tanach?

What is a good source for large tables on the properties of water?

Is it true that real estate prices mainly go up?

How is the Swiss post e-voting system supposed to work, and how was it wrong?

Select rows where one row meets a condition

0

I have a table with 3 columns:

UserId  ProductId    Status

1       100       1

1       1       0

2       100       0

4       100       0

5       1       1

5       100       1

6       2       1

I want to select all rows that have ProductId = 100 at least once per user and the user has atleast one more record other than with productId = 100.

Expected results:

UserId  ProductId    Status

1       100       1

1       1       0

5       1       1

5       100       1

I solved it like this by referring to another solution:

select "productId", "UserId", "mm_status"

from "MyTable"

WHERE EXISTS (

    SELECT 1 FROM "MyTable" WHERE "ProductId" = 100

)

But it returns all users where even one record is 100.

mysql postgresql

share

asked 1 min ago

asanasasanas

101

New contributor

asanas is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

0

I have a table with 3 columns:

UserId  ProductId    Status

1       100       1

1       1       0

2       100       0

4       100       0

5       1       1

5       100       1

6       2       1

I want to select all rows that have ProductId = 100 at least once per user and the user has atleast one more record other than with productId = 100.

Expected results:

UserId  ProductId    Status

1       100       1

1       1       0

5       1       1

5       100       1

I solved it like this by referring to another solution:

select "productId", "UserId", "mm_status"

from "MyTable"

WHERE EXISTS (

    SELECT 1 FROM "MyTable" WHERE "ProductId" = 100

)

But it returns all users where even one record is 100.

mysql postgresql

share

asked 1 min ago

asanasasanas

101

New contributor

asanas is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

I have a table with 3 columns:

UserId  ProductId    Status

1       100       1

1       1       0

2       100       0

4       100       0

5       1       1

5       100       1

6       2       1

I want to select all rows that have ProductId = 100 at least once per user and the user has atleast one more record other than with productId = 100.

Expected results:

UserId  ProductId    Status

1       100       1

1       1       0

5       1       1

5       100       1

I solved it like this by referring to another solution:

select "productId", "UserId", "mm_status"

from "MyTable"

WHERE EXISTS (

    SELECT 1 FROM "MyTable" WHERE "ProductId" = 100

)

But it returns all users where even one record is 100.

mysql postgresql

share

asked 1 min ago

asanasasanas

101

New contributor

asanas is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

UserId  ProductId    Status

1       100       1

1       1       0

2       100       0

4       100       0

5       1       1

5       100       1

6       2       1

UserId  ProductId    Status

1       100       1

1       1       0

5       1       1

5       100       1

select "productId", "UserId", "mm_status"

from "MyTable"

WHERE EXISTS (

    SELECT 1 FROM "MyTable" WHERE "ProductId" = 100

)

share

asked 1 min ago

asanasasanas

101

New contributor

asanas is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

share

asked 1 min ago

asanasasanas

101

New contributor

asanas is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

asked 1 min ago

asanasasanas

101

New contributor

asanas is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

asked 1 min ago

asanasasanas

101