查看一个表是否有相同记录的sql

 

select count(1) from tb_user;-------------1

 

 

select count(1) from (select distinct * from tb_user) temp;-------------2

 

if (sql 1==sql 2)that means not exist the duplicate record in table tb_user,otherwise exist the duplicate record.