SQL SELECT DISTINCT: Performance Best Practices
Is SQL DISTINCT good (or bad) when you need to remove duplicates in results? Some say...
Understanding SQL DELETE Column from Table
Adding and removing columns are among the most common tasks when you manage tables in databases. And it might seem strange, but many users...
TOP 5 MySQL Delete Syntax with Tips for T-SQL Developers
Our journey to MySQL started with CREATE TABLE followed by INSERT. Today, we are proceeding to the MySQL DELETE statement....
SQL Server DELETE – Removing One or More Rows from a Table with Slightly Advanced Scenarios
The current article focuses on slightly advanced use of the DELETE statement to remove one or more...
SQL Server Delete Statement: How to Remove One or Multiply Rows from the Table
The right application of the DELETE statement for data removal is crucial, and it involves lots of issues. Still, there are standard...
Difference Between DELETE and TRUNCATE Table in SQL Server
Many articles have been written to describe the difference between the SQL DELETE and SQL TRUNCATE statements. Moreover, it is one of the...
