Top "Where-clause" questions

A syntactic form in functional languages used to bind a value to a name in a local scope.

How do I create a conditional WHERE clause?

I need to have a conditional where clause that operates as so: Select * From Table If (@booleanResult) Begin Where Column1 = …

sql sql-server-2005 where-clause
MYSQL use 'LIKE' in 'WHERE' clause to search in subquery

How would you use 'LIKE' to search in a subquery? E.g. i've tried doing this, but doesn't work: SELECT * …

mysql sql subquery where-clause sql-like
SQL - improve NOT EXISTS query performance

Is there a way I can improve this kind of SQL query performance: INSERT INTO ... WHERE NOT EXISTS(Validation...) The …

sql sql-server performance where-clause not-exists
Running SQL user defined function that returns boolean, in where clause

Hope this doesn't seem too simple. I've looked this up but I'm not so good at SQL user defined functions …

sql function sql-server-2008-r2 boolean where-clause
SSAS MDX WHERE clause syntax - filtering multiple values from the same hierarchy

I'm quite new to data warehousing and MDX queries, and I realize that I'm probably not using the MDX syntax …

sql-server ssas mdx where-clause olap
WHERE clause in SSRS expression

What's the syntax for inserting a WHERE clause in an SSRS expression? I am using BIDS 2008. =Sum(Fields!QuantityToShip.Value) …

ssrs-2008 where-clause ssrs-expression stackedbarseries
T-SQL Conditional WHERE Clause

Found a couple of similar questions here on this, but couldn't figure out how to apply to my scenario. My …

sql sql-server tsql where-clause case-statement
MySQL WHERE <multiple-column> IN <subquery>

Is there a way (without JOIN) to use the WHERE clause on 2 columns (OR) IN a subquery? Currently, I'm doing …

mysql where-clause multiple-tables in-subquery
WHERE clause with nested multiple conditions

I want to retrieve data with conditions in WHERE clause. Here is my table something look like: Name Location Age …

sql sql-server case where-clause multiple-conditions
MySQL user-defined variable in WHERE clause

I want to know if there is a way to use a user-defined variable in WHERE clause, as in this …

mysql where-clause