求查询重复记录的SQL语句

Question

www.bjcan.com/hengxing/more.aspSQL中有收集

Answer 1

select a.* from tbl as a inner Join 
(
Select companyindex,ext_leaguename,ext_teamaname
from tbl
group by companyindex,ext_leaguename,ext_teamaname
having count(1)>1) as b 
 on a.companyindex=b.companyindex and a.ext_leaguename=b.ext_leaguename
    and a.ext_teamaname=b.ext_teamaname

Answer 2

下例使用 DISTINCT 防止检索重复的作者 ID 号：USE pubs
SELECT DISTINCT au_id
FROM authors
ORDER BY au_id

Answer 3

select * from tb group by companyindex,   ext_leaguename, ext_teamaname having count(1)>1

Answer 4

WangZWang(阿来)的能求出只是二条重复的记录.如是三条,四条重复的就不行了.

Answer 5

select a.* from tb_external_matches_abstract a inner Join
(Select companyindex,ext_leaguename,ext_teamaname
from tb_external_matches_abstract
group by companyindex,ext_leaguename,ext_teamaname
having count(1)>1) as b on a.companyindex=b.companyindex and a.ext_leaguename=b.ext_leaguename
and a.ext_teamaname=b.ext_teamaname
查询出是290条
Select companyindex,ext_leaguename,ext_teamaname,ext_teambname,count(*) as cont from
tb_external_matches_abstract where sys_status is null Group By
companyindex,ext_leaguename,ext_teamaname,ext_teambname Having Count(*)>1
查询出是107条(二条重复的有94,三条重复的有13.这样加上就是227条)
第一个查询就多出63条

Answer 6

WangZWang(阿来),你的QQ是多少?能加一个吗.我的是22878366