法一:
SELECT * FROM dbo.LimitIp WHERE Limit_Ip In (Select Limit_Ip From dbo.LimitIp Group By Limit_Ip Having Count(*)>1)
说明:
dbo.LimitIp:数据表......