Explanation of delete, truncate and joins in SQL

• DELETE statement removes specific rows from a table

• TRUNCATE statement removes all rows from a table

• JOIN statement combines rows from two or more tables ...read more