Alias in SQL query

Alias in SQL Query why you need it

Giving alias name is not only enough and you also need to know these three rules before you write your SQL query