Top "Where" questions

StrongLoop Loopback Model find with OR condition on WHERE filter

I'm trying to find a person by either their name OR identifier using StrongLoop's Model.find syntax (documentation here: http://…

filter find where strongloop

Create fully dynamic where clause with expression tree and execute on IQueryable

At point (3) in my code I have defined a query called query1 in which I defined a .Where lambda expression. …

c# lambda expression-trees iqueryable where

SQL order of operations

If I run the following SQL query SELECT * FROM A LEFT JOIN B ON A.foo=B.foo WHERE A.…

sql join optimization where sql-execution-plan

Difference between "on .. and" and "on .. where" in SQL Left Join?

Sql statement. 1.select a.* from A a left join B b on a.id =b.id and a.id=2; 2.select …

sql join syntax where

LINQ where Clause doubt

I have tried one where clause in Linq to get details about Users those who are Active and AllowLogin is …

c# linq where clause

How to invert numpy.where (np.where) function

I frequently use the numpy.where function to gather a tuple of indices of a matrix having some property. For …

python numpy boolean where indices

SQL - Where criteria to find names between A-F

Simple question: I need a solution so that I can find, lets say names, between A-F, INCLUDING all names that …

sql sql-server search where between

LINQ WHERE statement/ignore conditions

I need to ignore some or all conditions in WHERE statement if parameter is null or empty F.E: I …

c# linq where ignore conditional-statements

MySQL where clause and ordering by avg() as a sub query

Although I can group and order by on an aliased sub query, I can't use the alias in a where …

mysql subquery where average clause

Where to place and configure IoC container in a WPF application?

I am working on a middle sized WPF application (MVVM) that should be extensible and maintainable in the future. Thus …

wpf inversion-of-control unity-container containers where