What is the AS statement in SQL? The AS keyword in SQL is used to create a temporary alias for a table or column. This alias can be used instead of the name in the SELECT statement.

The SQL language has three different ways of naming things: identifiers, table aliases, and column aliases. These are just nicknames we give things so they’re easier to talk about and work with. A good example of this would be your email address. It may be anything you want it to be. However, many people choose to use their first initial and last name instead of full names, so that they’re easier to find.

TLDR!

The AS statement is a very important part of SQL. It can be used to assign table aliases or column aliases, or it can create temporary tables for storing intermediate results in your query.

#sql server #sql as #sql