Difference between Delete vs Truncate
DELETE is used to remove rows from a table based on specified conditions.
TRUNCATE removes all rows in a table without any conditions. It cannot be used to selectively delete specific rows.
Difference between Where vs Having
Context:
WHERE is used to filter rows based on individual records before any grouping or aggregation.
HAVING is used to filter the results of a query based on aggregated values after grouping.