Best way to delete duplicate rows

What’s best way to delete duplicate rows from DB when using DataAbstract?


what platform (Delphi or .NET) you are using?
what DB (MSSQL, MySQL, etc) you are using?

Delphi and SQL Express.


the best way - do it via command/stored procedure on MSSQL side w/o usage of delphi code
another way - you can download all records to delphi project, manually detect duplicates, mark them and delete consistently

Thanks for answer. Made StoredProc to MSSQL and used Devarts SDAC.