mysql如何查询不重复的行内容

select  *, count(*) as p_sum from p_table_name group by p_name;

select count(distinct p_id) as num from p_table_name;