We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
delete * from [dbo].[commerce_manufacturer_staging] where exists ( select * from [dbo].commerce_manufacturer_staging as a where a.[Name] = [dbo].commerce_manufacturer_staging.[Name] and a.[TypeId] = [dbo].commerce_manufacturer_staging.[TypeId] and a.[id] < [dbo].commerce_manufacturer_staging.[id] )
SELECT [Name],typeid, count([Name]) FROM commerce_manufacturer_staging GROUP BY [Name],typeid having count([Name]) > 1
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|MySql Workbench outputting "OK" as result of queries.||5||50|
|query output (script) from a stored procedure||4||51|
|T-SQL: How to append a column for serialized JSON data?||2||49|
|SQL - Using an 'array' kind of variable||5||12|
Join the community of 500,000 technology professionals and ask your questions.