SQL查询重复记录

有ABC三个字段,A字段相同而B字段不同,查询结果要达到:只要是A字段相同的记录都显示出来,我用了select * from pa3 group by a having count(a)>1,错误提示是:该列既不包含在聚合函数中，也不包含在 GROUP BY 子句中,该怎么写这个语句

---

select * from pa3 where a in (select a from pa3 group by a having count(a)>1)

---

select * from pa3 where a in (select a from pa3 group by a having count(a)>1)
或者(A字段相握前同而段丛清B字段不同)
select * from pa3 t1 where exists (select 1 from pa3 t2 where t1.a=t2.a and t1.b <>郑改 t2.b)

---

select * from pa3 where a in (select a from pa3 group by a having count(a)>1)

---

select * from pa3 where pa3.A in (select pa3.A from pa3 group by pa3.A having count(A)>1) 试试这祥清伍个谨或，正悄

---

select * from pa3 group by a,b,c having count(a)>1

---