在Sql Server中查找表中的所有重复项

I have a table which contains two columns of Urls and it contains duplicates.I'm looping through each row but have no idea to check duplicates.I want to send oldurl as parameter to check duplicates and get them.I don't want count but the list of all the duplicates.Can anyone help meI have a table which contains two columns of Ur