PHP+MYSQL的SQL语句读取重复数据

//列出所有记录，如有重复的只输出一条
$sql="select *, count(distinct j_name) from table group by j_name";

//只列出重复的数据
$sql='select id,j_name,count(*) from table group by j_name having count(*)>1';