帮忙写一个SQL语句

[xiaofhua]

表docstatrec 存在两个字段docstatdoccode、docstatdocno。
写一个SQL语句，查找出两个字段同时相同的所有数据。

[txlicenhe]

Select docstatdoccode、docstatdocno from docstatrec
group by docstatdoccode、docstatdocno
having count(*) > 1 -- having sum(1) > 1 也可

[yujohny]

select * from docstatrec where docstatdoccode = docstatdocno

[pengdali]

select docstatdoccode,docstatdocno from docstatrec group by docstatdoccode,docstatdocno having sum(1)>1

[xiaofhua]

表docstatrec 存在两个字段docstatdoccode、docstatdocno。
写一个SQL语句，查找出两个字段同时相同的所有数据。
比如
docstatdoccode docstatdocno
数据A: 部门样板领用 SAMPLE2002001
数据B: 部门样板领用 SAMPLE2002001
好像都不对也。急用！

[pengdali]

select * from docstatrec tem where exists (select 1 from docstatrec group by docstatdoccode,docstatdocno having sum(1)>1 and docstatdoccode=tem.docstatdoccode,docstatdocno=tem.docstatdocno)

[xiaofhua]

select 1 from docstatrec group by docstatdoccode,docstatdocno having sum(1)>1
是什么意思？

[txlicenhe]

Select docstatdoccode,docstatdocno from docstatrec
group by docstatdoccode,docstatdocno
having count(*) > 1 -- having sum(1) > 1 也可

[wozhuchuanwei]

Create Table Test(A VarChar(255),B VarChar(255))
INSERT INTO TEST (a,b) VALUES ('aaaa','aaaaa')
INSERT INTO TEST (a,b) VALUES ('aaa','aaaaa')
INSERT INTO TEST (a,b) VALUES ('aa','aaaaa')
INSERT INTO TEST (a,b) VALUES ('aa','aaaa')
INSERT INTO TEST (a,b) VALUES ('aaaa','aaaa')
SELECT * FROM TEST WHERE a=b
DROP Table TEST


-----
aaaa aaaa

[lilcjlong]

select * from docstatrec
where exists
(select tem1.docstatdoccode,tem1.docstatdocno
from docstatrec tem1 INNER JOIN docstatrec tem1
ON tem1.docstatdoccode=tem2.docstatdoccode,tem1.docstatdocno=tem2.docstatdocno
)
group by docstatdoccode
having count(*)>1

[lilcjlong]

select * from docstatrec
where exists
(select tem1.docstatdoccode,tem1.docstatdocno
from docstatrec tem1 INNER JOIN docstatrec tem2
　ON tem1.docstatdoccode=tem2.docstatdoccode　AND　　　　　　　　　　　　　　　　　　　tem1.docstatdocno=tem2.docstatdocno
)
group by docstatdoccode
having count(*)>1
最后一行不知对不对！

[Sorder]

Select docstatdoccode,docstatdocno from docstatrec
group by docstatdoccode,docstatdocno
having count(docstatdoccode) > 1 or having count(docstatdocno) > 1

[dafu71]

select * from docstatrec xx where docstatdoccode=(select max(docstatdoccode) from docstatrec where docstatdocno=xx.docstatdocno group by docstatdoccode having count(*)>1)