How to Find Duplicate values in SQL?

How to Find Duplicate values in SQL?
CREATE TABLE [dbo].[emp]
(
[id] [int]  NULL,
[name] [varchar](20) NULL,
[city] [varchar] (20) NULL,
[dept] [varchar](10) NULL,
[salary] [money] NULL

)

insert into emp values(100,'Kishore','bangalore','IT',48000)
insert into emp values(101,'pavan','bangalore','HR',32000)
insert into emp values(102,'mahesh','pune','Slaes',24000)
insert into emp values(103,'harish','mumbai','IT',42000)
insert into emp values(104,'ramya','pune','HR',28000)

insert into emp values(105,'swetha','bangalore','Slaes', 26000)
insert into emp values(102,'mahesh','pune','Slaes',24000)
insert into emp values(103,'harish','mumbai','IT',42000)

insert into emp values(104,'ramya','pune','HR',28000)
 Actual Table:

Required table:

Query:

select id,name,city,dept,salary from
(
          select id,name,city,dept,salary,COUNT(id)as cnt 
          from emp
          group by salary,dept,city,name,id

          having COUNT(id)>1
)as kk