84669 person learning
152542 person learning
20005 person learning
5487 person learning
7821 person learning
359900 person learning
3350 person learning
180660 person learning
48569 person learning
18603 person learning
40936 person learning
1549 person learning
1183 person learning
32909 person learning
,例如major_id = 1 and major_id=2 and major_id=3,怎么构建sql语句那
数据库结构
id student_id marjor_id create_time
ringa_lee
你的问题有不明确啊所有student_id,学生ID,student_id不就是学吗???还有major_id = 1 and major_id=2 and major_id=3这个语句肯定查不到任何数据的
select student_id from(select student_id,count(1) as cnt from table where marjor_id in(1,2,3,4) group by student_id) t where t.cnt=4
你的问题有不明确啊
所有student_id,学生ID,student_id不就是学吗???
还有major_id = 1 and major_id=2 and major_id=3这个语句肯定查不到任何数据的
select student_id from(
select student_id,count(1) as cnt from table where marjor_id in(1,2,3,4) group by student_id
) t where t.cnt=4