In the below code i have created the temp table and inserted few duplicate records then wrote the query to find duplicates:
create table #temp
(id int identity(1,1),
City varchar(50),
state varchar(50)
)
insert into #temp
select 'HYD','AP'
union all
select 'HYD','AP'
union all
select 'PUNE','MH'
select * from #temp
select s.id, t.*
from #temp s
join (select City, state,count(*) as qty from #temp group by City, state having count(*) > 1) t on s.City = t.City and s.state = t.state
drop table #temp