我有一个这种形式的表：
id | firstname | lastname
---+-----------+----------
1 | alex | marti
2 | mark | finger
3 | alex | marti
4 | ted | port
需要归还firstname, lastname以这种形式重复：
1 | alex | marti
3 | alex | marti
我尝试做select firstname, lastname from t group by firstname, lastname having count(*) > 1但这会返回类似的东西
firstname | lastname
----------+----------
mark | finger
alex | marti
ted | port
我需要id重复的但当然select id, firstname, lastname from t group by id, firstname, lastname行不通的。
有任何想法吗？谢谢。
select a.* from t a,
(select first, last from t group by first, last having count(*) > 1) b
where a.first = b.first and a.last = b.last
本文内容由网友自发贡献，版权归原作者所有，本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容，请联系:hwhale#tublm.com(使用前将#替换为@)
