What is the role of the alias e in the following query?
SELECT e.Name FROM Employees e WHERE e.Department = 'IT';

Question

What is the role of the alias  e  in the following query? 
 SELECT e.Name FROM Employees e WHERE e.Department = 'IT';

Accepted Answer

It is a table alias used to simplify references

Answer

It is used to rename the table permanently

Answer

It filters out duplicate rows

Answer

It prevents errors in case of missing column names

Crowdly