Integreat Concepts (A Med3000 Company) interview question
How do you delete duplicate rows from a table?
Interview Answer
Anonymous
17 Jul 2009
Use a NOT EXISTS() to a subquery containing a MIN() or MAX() aggregate, or use ROW_NUMBER.
How do you delete duplicate rows from a table?
Anonymous
Use a NOT EXISTS() to a subquery containing a MIN() or MAX() aggregate, or use ROW_NUMBER.
Check out your Company Bowl for anonymous work chats.