题解 | #查询结果去重#

解法一：内连接

SELECT q.device_id,q.question_id,q.result
FROM question_practice_detail as q INNER JOIN user_profile as u ON q.device_id = u.device_id
WHERE u.university = "浙江大学"

解法二：子查询

SELECT device_id,question_id,result
FROM question_practice_detail as q
WHERE q.device_id in (SELECT u.device_id
                      FROM user_profile as u
                      WHERE u.university = "浙江大学")