select * from tab where group by name distinct 是这样吗?
select name,count(*) from table group by name having count(*)>1 ___________________________________________________________________ 苦闷中………………………… ___________________________________________________________________
是这样的,比如说name,有两个同名的(比如有两个都叫'黎明');
那么我就取出,只要有重名的都要取出来(名字不重复的不取)
这个SQL语句怎么写?
是这样吗?
___________________________________________________________________
苦闷中…………………………
___________________________________________________________________