Is there any difference between these two syntaxes? select * from (some query) result select * from (some query) AS result
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