DECLARE @Tracks TABLE(TrackID int NOT NULL, TrackName varchar(50) NOT NULL,
GenreID int NOT NULL,ArtistId int NOT NULL);

DECLARE @GenreTracks TABLE(ID int NOT NULL IDENTITY(1,1),TrackId int NOT NULL,
GenreId int NOT NULL);

INSERT @Tracks(TrackID,TrackName,GenreID,ArtistId)
SELECT 100,'Track-100',100,100
UNION ALL
SELECT 200,'Track-200',100,100
UNION ALL
SELECT 300,'Track-300',100,200
UNION ALL
SELECT 400,'Track-400',400,200
UNION ALL
SELECT 500,'Track-500',500,300
UNION ALL
SELECT 100,'Track-100',400,100
UNION ALL
SELECT 100,'Track-100',500,100

INSERT @GenreTracks(GenreId,TrackId)
SELECT DISTINCT GenreID,TrackID FROM @Tracks;

;WITH CTE AS 
(
	SELECT ROW_NUMBER() OVER (PARTITION BY TrackId,ArtistId ORDER BY ArtistID) RowCtr,
	TrackID,
	TrackName,
	ArtistId,
	GenreID
	FROM @Tracks
)
-- the data to be retained
SELECT 'FinalList',TrackID,TrackName,ArtistId FROM CTE WHERE RowCtr = 1;
-- run this delete to delete data and retain what is needed
--DELETE CTE WHERE RowCtr > 1
-- drop the GenreId column after deleting the rows

SELECT 'FullList',* FROM @Tracks;
SELECT * FROM @GenreTracks;