-- Removing duplicate rows
DELETE FROM PortfolioProject.dbo.Goodreads
WHERE isbn = '0439023483'
AND id <> (SELECT MIN(id)
FROM PortfolioProject.dbo.Goodreads
WHERE isbn = '0439023483');
-- Removing duplicate rows
DELETE FROM PortfolioProject.dbo.Goodreads
WHERE isbn = '0439023483'
AND id <> (SELECT MIN(id)
FROM PortfolioProject.dbo.Goodreads
WHERE isbn = '0439023483');