Learn SQL Alises

In this chapter you will learn:
About aliases
Example of aliases

About aliases

SQL aliases are used to refer to the table with another name or to uniquely identify the table. It is defined in the FROM clause of the SELECT statement. It became mandatory to use a table alias when listing the column names in the SELECT statement due to duplicate column name in multiple tables.

Example of aliases

select e.employeeid, e.title, emp.rate,
emp.payfrequency from humanresources.employee e join
humanresources.employeepayhistory emp on e.employeeid=emp.employeeid


aliases example image

SUMMARY In this chapter, you have learned about SQL aliases with one example. In the next chapter you will get search data exercise.

More Articles

 

Share your thought



PLEASE DISABLE ADBLOCKER AND SUPPORT US!

Please support us by enabling ads on this page. Refresh

YOU DON'T LIKE ADS, WE ALSO DON'T LIKE ADS!
 
But we have to show ads on our site to keep it free and updated. We have to pay huge server costs, domain costs, CDN Costs, Developer Costs, Electricity and Internet Bill. Your little contribution will encourage us to regularly update this site.