SQL Use alias in Where statement

by

You can use “having” instead of “where”.

SELECT
    SUBSTRING(Column1, 1, 4) + SUBSTRING(Column1, 4, 3)  AS Col1
FROM
    MyTable
HAVING
    Col1 = 'MySearch'

Having do a “where” after execution of the query.
Be careful to use it in the right conditions to have no performance problem.

More Related Contents:

  1. SQL is null and = null [duplicate]
  2. Aggregate columns with additional (distinct) filters
  3. Reset identity seed after deleting records in SQL Server
  4. How to avoid the “divide by zero” error in SQL?
  5. SQLite Reset Primary Key Field
  6. Using an ORM or plain SQL? [closed]
  7. Insert data in 3 tables at a time using Postgres
  8. Better techniques for trimming leading zeros in SQL Server?
  9. Fulltext Search with InnoDB
  10. How to declare variable and use it in the same Oracle SQL script?
  11. List of special characters for SQL LIKE clause
  12. Dynamic SELECT TOP @var In SQL Server
  13. Laravel Eloquent: sum with groupBy
  14. Are a CASE statement and a DECODE equivalent?
  15. Can you access the auto increment value in MySQL within one statement?
  16. Generate script in SQL Server Management Studio
  17. In SQL, is UPDATE always faster than DELETE+INSERT?
  18. How can I alter this computed column in SQL Server 2008?
  19. How to get the size of a varchar[n] field in one SQL statement?
  20. SQL Server Update Group by
  21. Query for getting value from another record in same table and filter by difference greater than a gap threshold
  22. Cannot create an instance of OLE DB provider Microsoft.Jet.OLEDB.4.0 for linked server null
  23. Closing connection when using Dapper
  24. SQL CREATE LOGON – can’t use @parameter as username
  25. What does collation mean?
  26. How to get the last day of month in postgres?
  27. Try_Convert for SQL Server 2008 R2
  28. SQL: Using DATEADD with bigints
  29. converting int to real in sqlite
  30. Concat all column values in sql

Leave a Comment