Using alias in query and using it

by

You are talking about giving an identifier to an expression in a query and then reusing that identifier in other parts of the query?

That is not possible in Microsoft SQL Server which nearly all of my SQL experience is limited to. But you can however do the following.

SELECT temp, temp / 5
FROM (
    SELECT (a/b) AS temp
    FROM xyz
) AS T1

Obviously that example isn’t particularly useful, but if you were using the expression in several places it may be more useful. It can come in handy when the expressions are long and you want to group on them too because the GROUP BY clause requires you to re-state the expression.

In MSSQL you also have the option of creating computed columns which are specified in the table schema and not in the query.

More Related Contents:

  1. SQL – using alias in Group By
  2. Using an Alias in a WHERE clause
  3. Why can’t I use alias in a count(*) “column” and reference it in a having clause?
  4. How to write UPDATE SQL with Table alias in SQL Server 2008?
  5. PostgreSQL does not accept column alias in WHERE clause
  6. ORA-00972 identifier is too long alias column name
  7. Using Alias In When Portion of a Case Statement in Oracle SQL
  8. Why doesn’t Oracle SQL allow us to use column aliases in GROUP BY clauses?
  9. How can I insert a new database record in the middle of an existing table?
  10. Convert text to system date format [duplicate]
  11. SQL Access ” Count “? [closed]
  12. What are the options for storing hierarchical data in a relational database?
  13. SQL update from one Table to another based on a ID match
  14. A beginner’s guide to SQL database design [closed]
  15. Check if a row exists, otherwise insert
  16. Pivoting data in MS Access
  17. coalesce alternative in Access SQL
  18. Postgres Dynamic Query Function
  19. How do I delete a fixed number of rows with sorting in PostgreSQL?
  20. How to check if a string is a uniqueidentifier?
  21. Entity Framework – attribute IN Clause usage
  22. How to see the values of a table variable at debug time in T-SQL?
  23. Generating dates between two dates
  24. Designing a SQL schema for a combination of many-to-many relationship (variations of products)
  25. Doesn’t Linq to SQL miss the point? Aren’t ORM-mappers (SubSonic, etc.) sub-optimal solutions?
  26. SQL ORDER chars numerically
  27. Should I use the CASCADE DELETE rule? [duplicate]
  28. Does MS access(2003) have anything comparable to Stored procedure. I want to run a complex query in MS acceess
  29. SQL, How to Concatenate results?
  30. ALTER TABLE without locking the table?

Leave a Comment