如何将一个表中的某一个字段值相同的记录查出来

[wong99]

如何将一个表中的某一个字段值相同的记录查出来

[cqcjoe]

select *
from employee
where job_id in (select distinct job_id from employee)

[蓝天]

select yourcolumn from yourtable group by yourcolumn having count(*) >1

[蓝天]

select * from yourtable where yourtable in (select yourcolumn from yourtable group by yourcolumn having count(*) >1)

[pengdali]

select *
from 表
where 列 in
(select 列 from(select 列,count(列) a from 表 group by 列) AA where a>1)

[pengdali]

呵呵！多种解法！