Tag: sql delete

Is SQL DISTINCT Good for Removing Duplicates in Results?

05:57 Database development, Statements

Is SQL DISTINCT good (or bad) when you need to remove duplicates in results? Some say...
Read More

TOP 5 MySQL Delete Syntax with Tips for T-SQL Developers

12:12 Database development, Languages & Coding, Statements, T-SQL

Our journey to MySQL started with CREATE TABLE followed by INSERT. Today, we are proceeding to the MySQL DELETE statement....
Read More

SQL Server DELETE – Removing One or More Rows from a Table with Slightly Advanced Scenarios

18:21 Database development, Statements, Tables, Work with data

The current article focuses on slightly advanced use of the DELETE statement to remove one or more records (rows) from a table. While it...
Read More

SQL Server Delete Statement: How to Remove One or Multiply Rows from the Table

16:23 Database development, Statements, Tables

The right application of the DELETE statement for data removal is crucial, and it involves lots of...
Read More

Difference Between DELETE and TRUNCATE Table in SQL Server

11:01 Database development, Statements, Tables

Many articles have been written to describe the difference between the SQL DELETE and SQL TRUNCATE statements. Moreover, it is one of the...
Read More