Select duplicate records without count or group by

Below is the simple query of selecting duplicate records without using count or group by.

/* Create temp variable table */

DECLARE @tempRecords AS TABLE  (RecordId INT IDENTITY(1,1), FName VARCHAR(10), LName VARCHAR(10))

/* Insert Data to temp tabel */

INSERT INTO @tempRecords(FName, LName) VALUES('A', 'B'), ('A','B'), ('C','D'),('C','E'),('A','E'),('C','D'),('A','B')

/* Select All records */

SELECT * FROM @tempRecords

/* Select Duplicate records only with all columns */

SELECT DISTINCT a.* FROM @tempRecords a INNER JOIN @tempRecords b

ON a.FName = b.FName

AND a.LName = b.LName

AND a.RecordId <> b.RecordId

ORDER BY a.FName, a.LName

Here we select duplicate records by self joining.