Skip to content

Tag: alias

SQL alias for SELECT statement

I would like to do something like Is it possible to somehow do the “AS my_select” part (i.e. assign an alias to a SELECT statement)? (Note: This is a theoretical question. I realize that I can do it without assign an alias to a SELECT statement, but I would like to know whether I can do it with that.) Answer

Using alias in query and using it

I have a doubt and question regarding alias in sql. If i want to use the alias in same query can i use it. For eg: Consider Table name xyz with column a and b Is this possible in some way ? Answer You are talking about giving an identifier to an expression in a query and then reusing that