Fetching a Duplicate Row from a Table in SQL Server

This blog defines the procedure of fetching a duplicate row from a table in SQL Server.

--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