查询一个表中的两个字段值相同的数据
查询一个表中的两个字段值相同的数据
日期:2018-11-08 12:54:32 人气:1
select LinkUser.* from LinkUser INNER JOIN (SELECT Lname,UserName from LinkUser group by Lname,UserName having count (*)>1) AS B ON LinkUser.Lname =B.Lname AND LinkUser.UserName=B.UserName ORDER BY LinkUser.UserName
SELECT Lname,UserName from LinkUs