--Create a table
Declare @employee table(ID int ,name varchar(10), salary money) --Insert values into the table
insert into @employee(id,name,salary)
values(1,'ashok' ,20000),(1,'ashok',20000) , (2,'sejal',15000) , (3,'vinod',56985) --Write a query to view the duplicate record
select * from @employee group by ID, name, salary
having count(*)>1