Filter based on an aliased column name Asked 15 years, 9 months ago Modified 7 years, 9 months ago Viewed 30k times

SQL: Filtering a query with multiple conditions Asked 12 years, 3 months ago Modified 12 years, 2 months ago Viewed 32k times

Aside from the dirty feeling I get when doing dynamic SQL, my query is fairly large (I'm selecting a couple dozen fields, joining 5 tables, calling a couple of functions), so it's a big giant string all …

May 24, 2010 · How do I filter one of the columns in a SQL Server SQL Query Asked 15 years, 6 months ago Modified 15 years, 6 months ago Viewed 32k times

Oct 29, 2010 · I'm making select with a union. SELECT * FROM table_1 UNION SELECT * FROM table_2 Is it possible to filter query results by column values?

Jul 21, 2013 · The bottom line here is: If you need to filter out rows within the window of the analytic function, move the analytic function to a subquery and filter in the outer query as per …

May 24, 2012 · I have a column in my table for dates (DateTime) and I am trying to create a WHERE clause that says, WHERE dates BETWEEN 12-11-2012 and 12-13-2012 A sample …

Dec 2, 2011 · On several SQL queries I need to check if a field starts with a character. There are several ways to do it, which one is better in performance/standard? I usually use tb.field LIKE …

I want to filter SQL Audits so that I do not want to capture events triggered by certain users and certain schema. In one of the existing Server Audit, I found the filter predicate as ( [schema_n...

I have a relatively simple query joining two tables. The "Where" criteria can be expressed either in the join criteria or as a where clause. I'm wondering which is more efficient. Query is to fi...