有一个需求,对于表TEST:
需要查出科目和成绩相同的同学的行,即查询结果如下所示:
那么SQL语句如下所示:
select * from test t where id in(
select id from(select testnum,testtag from test group by testnum,testtag having count(*)>=2)m
where m.testnum=t.testnum and m.testtag=t.testtag
)
有一个需求,对于表TEST:
需要查出科目和成绩相同的同学的行,即查询结果如下所示:
那么SQL语句如下所示:
select * from test t where id in(
select id from(select testnum,testtag from test group by testnum,testtag having count(*)>=2)m
where m.testnum=t.testnum and m.testtag=t.testtag
)