84669인 학습
152542인 학습
20005인 학습
5487인 학습
7821인 학습
359900인 학습
3350인 학습
180660인 학습
48569인 학습
18603인 학습
40936인 학습
1549인 학습
1183인 학습
32909인 학습
,例如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