Find all users who rated all the movies rated by a specific user So we have the following relational schema:

users(user_id, ..)
movies(movie_id, ..)
ratings(user_id, movie_id, rate)


So, we want to find all the users who have rated all the movies which are rated by a specific user '1234'

In other words, if user '1234' has rated movies 1, 2, 3, and 4, we want the user ID of all others who have also rated movies 1, 2, 3, 4.
This will not suffer from duplicate votes

SELECT user_id
FROM ratings 
WHERE movie_id IN (SELECT movie_id FROM ratings WHERE user_id = '1234') AND user_id &lt;&gt; '1234'
GROUP BY user_id 
HAVING count(DISTINCT movie_id) = (SELECT count(DISTINCT movie_id) FROM ratings WHERE user_id = '1234')