mysql - 查询所有和我看过同样电影的人

Question

假设我看过不止一部电影，我如何找到所有也看过我看过的所有电影的人？

     MovID  Name   Movie name
    ---------------------
    1     | me     |Batman
    2     | me     |Spider Man
    1     | Jason  |Batman
    2     | Jason  |Spider Man
    3     | Jason  |King kong 
    3     | Jim    |King kong
    4     | Jim    |Titanic

结果应该给我杰森。谢谢!

Answer 1

这是一种方法:

select name
  from tbl
 where movid in (select movid from tbl where name = 'me')
   and name <> 'me'
 group by name
having count(*) = (select count(*) from tbl where name = 'me')

fiddle : http://sqlfiddle.com/#!9/3120e/2/0