Common
SELECT
Qualified column names
Use references to identify table's columns
E.g., SELECT c.name FROM customers c;
Otherwise, it might not able to map all columns from a table.
When a query involves multiple tables, it can be difficult to identify which column belongs to which table, especially if the tables have columns with the same names.
References should be qualified if select has more than one referenced table/view.
Learn more: references.qualification
Table aliases should be unique
Learn more: aliasing.unique.table
Last updated